Forum Discussion
Sort Month Year Slicer Descending
Hi All,
I have a 1-to-many join on a month table that filters my other 2 tables on month that contain my data. I'm trying to do a sort by column on my month table, but it's not changing the order of my slicer. Can anybody help with this? The messages on the forum I am reading are from like 5 years ago and the same features don't apply with what version Power BI is on now.
Thanks!
Hi, Anonymous
As you said, you have a MonthReverse Column present, so I assumed some data for testing:
You must make sure that the type of your MonthReverse Column is whole number:
Then drag the Month field into Slicer's Fields panel:
Then click on the Month field, find the Sort by column at the top and select the MonthReverse Column:
This gives you the freedom to choose whether your Month column is ascending or descending based on the MonthReverse Column:I've attached the pbix file for this little example below, hope it helps.
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
- nandic
Resident Rockstar
Anonymous , could you send screenshot of Month table and define which column is sorted by which column.
When you do sort by column step, there is no error message?
In that case, make sure that column that is used for sorting is numeric, not text.
Cheers,
Nemanja AndicHi nandic,
I'm sorting on the dimension table, which then sorts the fact tables I have the relationships set up with. My month column is converted to date type of "March 2021" date type. My month reverse column is numerical and I am trying to sort on that, but it doesn't change my date filter of "March 2021".
Hi, Anonymous
As you said, you have a MonthReverse Column present, so I assumed some data for testing:
You must make sure that the type of your MonthReverse Column is whole number:
Then drag the Month field into Slicer's Fields panel:
Then click on the Month field, find the Sort by column at the top and select the MonthReverse Column:
This gives you the freedom to choose whether your Month column is ascending or descending based on the MonthReverse Column:I've attached the pbix file for this little example below, hope it helps.
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
