Forum Discussion
Power bi
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?
1 Reply
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 sortuse month year on the Axis
