Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All
I have created a DAX calculation to generate the calendar Date as given below. After executing this code, i have got a table named 'Date' which has columns: Calendar Date, day, month, year.
I need to sort Calendar day in descending order in my slicer like most recent dates on top. Please let me know how can i do that. Thanks.
Date =
GENERATE (
CALENDARAUTO(),
VAR currentDay = [Date]
VAR day = DAY( currentDay )
VAR month = MONTH ( currentDay )
VAR year = YEAR ( currentDay )
RETURN ROW (
"day", day,
"month", month,
"year", year )
)
Solved! Go to Solution.
Hi @Divya904
It is possible to create a default sort order, but you need to generate a separate column that has negative values for each month and then use the "Sort by Column" feature to set the default order.
Hi @Divya904,
Click on the elipses on the top right corner of the slicer and change sort order to descending.
Prateek Raina
Hi @Divya904,
By default, every field is sorted in ascending order.
As of now, there is no way apart from the earlier approach I told, to modify the sort order in visuals.
Once you have changed the sort orders to descedning and then published the report, your users will see it in descending order only so they will not have to again sort as you have done it during report creation.
Prateek Raina
Hi @Divya904
It is possible to create a default sort order, but you need to generate a separate column that has negative values for each month and then use the "Sort by Column" feature to set the default order.
Hi @
On the slicer visual, click the three dots in the top right-hand corner, then chose the appropriate sort required. Be wary that you may need to click the name of the field to sort and then repeat to click the little A/Z icon to the left of the field name to control the sort direction
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |