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.
I have a Matrix that's essentially a Date Hierarchy & aggregated Financials. How do I make it such that this can be sorted both in Chronological order and Reverse Chronological Order? By default, Chronological order works but I cannot then get it to reverse. Everything I try seems to only sort a single level descendingly while the subgroupings flip back to be ascending. If I have a table with just any one of these fields in it, they sort correctly in both ascending and descending orders (i.e. the Sort By columns are properly set). The problem is specifically when say to sort the Matrix in a Descending way by Day, then the subgroup headers for Month, Quarter, and Year are Ascending but the Days within each Month are descending.
I specifically want a reverse-chronological order when "Descending" is selected and chronological order when "Ascending" is selected. I don't want to hack all of the levels to *always* be reverse-chronological order, I want the consumer to be able to switch back and forth between the two.
Fully-expanded hiearchy: Year -> Quarter -> Month -> Day
Desired (when Descending is selected):
2018: $11602 2018 Q4: $1234 2018 Q3: $2345 2018 Q2: $3456 2018 Q1: $4567 2017: $11602 2017 Q4: $1234 2017 Q3: $2345 2017 Q2: $3456 2017 Q1: $4567
What I get if I sort by Quarter (descending):
2017: $11602 2017 Q4: $1234 2017 Q3: $2345 2017 Q2: $3456 2017 Q1: $4567 2018: $11602 2018 Q4: $1234 2018 Q3: $2345 2018 Q2: $3456 2018 Q1: $4567
What I get if I sort by Year (descending):
2018: $11602 2018 Q1: $1234 2018 Q2: $2345 2018 Q3: $3456 2018 Q4: $4567 2017: $11602 2017 Q1: $1234 2017 Q2: $2345 2017 Q3: $3456 2017 Q4: $4567
Hi,
I'm not sure this is possible by default now to sort by two columns at once. There is the following idea if you want to vote for it:
I think you could create an additional column like this one:
What if I need to do this by Month? where my Month column is the name of the month.
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |