Forum Discussion

lemaribdb's avatar
lemaribdb
Helper II
2 years ago
Solved

2 fields slicer sort both levels

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 descendin...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    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.

Ritaf1983's avatar
Ritaf1983
Super User
2 years ago

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's avatar
lemaribdb
Helper II
2 years ago

Works like a charm, thanks!