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 set the matrix up as below:
On the drilldown buttons, I have pressed the right hand button labelled 'At the lowest level of data'.
As you can see, the total sort order sorts by inner row groups (Lift Reference) per outer row group (Site Name), not just by inner row group (Lift Reference). Is there any way to sort the total just for the inner row group (Lift Reference) but still show the outer row group (Site Name)?
Cheers for all help
Solved! Go to Solution.
HI @ansa_naz,
Nope, I don't think you can direct sort by sub-total level, power bi will drill to detail records and sort by them.
Current power bi support to use one of axis or value field as sort order, you can also refer to following link to use 'sort by column' to define default sort order or records.
Regards,
Xiaoxin Sheng
HI @ansa_naz,
Nope, I don't think you can direct sort by sub-total level, power bi will drill to detail records and sort by them.
Current power bi support to use one of axis or value field as sort order, you can also refer to following link to use 'sort by column' to define default sort order or records.
Regards,
Xiaoxin Sheng
Hi @v-shex-msft Im not sure I understand. Are you saying it is not possible to sort by the subtotal amount in a matrix?
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 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |