Year Month Comparision Clustered Column Chart in Power BI

[ktkpatra]

Dear Uesrs,

Could you please guide me how to create 2 or 3 year data with Month comparison as per graph below.

Do I need DAX or any other option can do it. please help.  

[Evan_Power_Bi]

Whatever your date hiearchy field is, take the "year" and put that in the "Legend" of the visual and put "month" in the "x-axis" of a clustered column chart.

[v-yueyunzh-msft]

Hi , @ktkpatra 

Can you explain what is " 2 or 3 year data with Month comparison as per graph below"?

In your cisual , it shows the "2021-2022" Month comparsion, and what is you really want ?

If you want to make a slicer , you can refer to :
Generate Year and Month Combinations in Power BI Report using DAX - RADACAD

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly