2 fields slicer sort both levels

[lemaribdb]

Hi!

I have a slicer with 2 fields, YEAR and YEAR_MONTH_NO, they come from separate calendar table. When I select to sort this slicer by YEAR -> Descending, the first level, years, are in descending order but the YEAR_MONTH_NO inside years is ascending. When I select to sort by YEAR_MONTH_NO, the year month inside the years are descending but then years itself are ascending. Two cases screenshoted. How to make them both descending? In data model the YEAR_MONTH_NO is sorted by other columnm (SORT_YEAR_MONTH_NO) and the year by "itself", nothing weird going on there. How to make them both descending?

[Ritaf1983 · Accepted solution]

Hi @lemaribdb 
You need to create a column for descending sorting in the date table :

and use it for sorting month-year

pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[lemaribdb]

Works like a charm, thanks!