Chart for Comparing current Year to Date & Prior Year to Date

Question on choosing a chart for showing location wise Purchase totals for the year & Month selected via slicer.

I have the Current YTD purchase total & Previous YTD totals. I want to show the Location & time ( Year & Month) in X axis and show a comparison of Totals. WHich chart is the standard option that i could use ?

HI @train,

You can have a look at this Visual reference document for various charts to be used under which conditions.

https://www.sqlbi.com/ref/power-bi-visuals-reference/

Regards,
Harsh Nathani

1 Like

Great resource @harsh.nathani!

I’ve also found this article is an informative read about which chart to select. It also has a great graphic to help with the initial decision process.

https://infogram.com/page/choose-the-right-chart-data-visualization

Though, I think in this case a simple clustered bar chart sorted largest to smallest by current purchase total would be the way to go here.

1 Like