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

Power BI
1

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 ?

2

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
3

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.

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