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,
I have a request for the current Matrix, where I would like to control the aggregation level of individuel parts of the matrix.
Currently if I filter down on three levels, the matrix will do this for all groups of data in the matrix, but I only want the matrix to do it for specific parts of the matrix, and only show the first aggregated level in my "Others" group.
Example of PBI today and my requested format:
Is it possible to achive this in dax?
I know this is related to the matrix collapse/expand button idea, but I need a workaround asap:
Currently my solution has been to make 3 seperate matrix, with one for North America / Europe, and then a second and third for "Others" and "Total" where I would hide the measure description. Kinda works but seems like a mess.
@Anonymous,
Please take a look at the following similar thread about how to add total of specific group in Matrix.
https://community.powerbi.com/t5/Desktop/Adding-a-custom-total-Row-and-Total-Column-for-matrix/td-p/200540
Regards,
Lydia
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 |
---|---|
107 | |
98 | |
78 | |
65 | |
53 |
User | Count |
---|---|
144 | |
103 | |
98 | |
85 | |
64 |