Forum Discussion

lemaribdb's avatar
lemaribdb
Icon for Helper II rankHelper 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
Icon for Super User rankSuper 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
    Icon for Helper II rankHelper II
    2 years ago

    Works like a charm, thanks!