Power bi

[Srishti]

Hi,

i have created a slicer of year, if I click on 2022 the data in chart is correct as per month but if I click on 2023, the data is coming date wise in chart, how to correct that?

 

 

[amitchandak]

@Srishti , Are you date on the axis?

Better to use Month year column on the axis (sorted on month year sort column)

Month Year = FORMAT([Date],"mmm-yyyy")
Month Year sort = FORMAT([Date],"yyyymm") //select month year and in column tools -Sort by column Month year sort

use month year on the Axis