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 suggestions?
11 Replies
Hari_Gopal So you generally need a column with the order you want and you use that as the "Sort by" column. Without seeing your data, it is hard to be more specific.
It's a general month name column and sorted by fiscal month number( Apr = 1 to Mar = 12) column.
Hari_Gopal Oh, I see it is sorting vertically versus horizontally. There is no setting that I know of to change that. However, if you shrink it vertically it will sort horizontally across.
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)
Hi Hari_Gopal
You can change the order in visual options, sort axis by fiscal month number and set Sort ascending . This operation does not affect the sequence of the slicer, because it is set in a single visual. You can have a try .
Best Regard
Community Support Team _ Ailsa Tao
Hi, once look at the below scenario
Hi Hari_Gopal
In my pbix file , you can find the ID for slicer and number for column chart are different columns , in column chart , the sorting is based on the column of Apr=1, May=2 as the standard .
I changed it in my pbix file and attached it again , you can refer to it .
Best Regard
Community Support Team _ Ailsa Tao
Hi, I did understand what you did.
The previous scenario what I mentioned has the following issuesa) If we select present fiscal year, months order is changing in slicer and
b) you placed number column in value field of bar chart but if we place some other value column in value field, how can we sort?
Hi Hari_Gopal
Then you can only start with the name of the X-axis value, and you can add an order in front, but the display is not so good. Create a calculated column and put it in Axis .
Column = 'Table'[number] & "-" &'Table'[Month]Best Regard
Community Support Team _ Ailsa Tao
