Forum Discussion

Hari_Gopal's avatar
Hari_Gopal
Icon for Advocate I rankAdvocate I
4 years ago

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...
Anonymous's avatar
Anonymous
Not applicable
4 years ago

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

Hari_Gopal's avatar
Hari_Gopal
Icon for Advocate I rankAdvocate I
4 years ago

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)