Forum Discussion
Month Slicer Sorting
Hello Everyone, When I placed month names in a slicer which was sorted according to Indian fiscal year month number, I got the 2nd visual. But I want to display as 1st visual. Any sug...
Hi Hari_Gopal
In slicer , there are two orientations for Slicer : Vertical and Horizontal .When you choose Horizontal , the visual displays as the screenshot below .
So if you want to change the location of the Month , you need add a column to define the order of the Month . Then sort the month by the ID in Data view .
You will get a visual like this :
I have attached my pbix file , you can refer to it .
Best Regard
Community Support Team _ Ailsa Tao
I also tried this way but the problem with this way is when we place this month column in bar chart, the order is different from the actual(apr, may, june ----mar)