2 fields slicer sort both levels

Question

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 -&gt; Descending, the first level, years, are in descending order but the YEAR_MONTH_NO inside years is ascending. When I select to sort by&nbsp;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?&nbsp;&nbsp;

ritaf1983 · Accepted Answer

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

and use it for sorting month-year

&nbsp;
pbix is attached
If this post&nbsp;helps, then please consider&nbsp;Accepting it as the solution&nbsp;to help the other members find it more quickly.

Forum Discussion

2 fields slicer sort both levels

2 Replies

Related content

Problem with field parameter and empty slicer

Dynamic Field Parameters with Two Slicers (Share Slicer + Group By Slicer)

Slicer pointing towards multiple fields

Selected field ratio and rank-Top N as slicer

Report level slicer