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.
Hello all,
I am building a report for a client and have shown their numbers in a matrix. They want to see number of licenses sold by category (Distributor, Suppliers etc), and then those categories are grouped into top-level headers by type. However, they don't want to include all of the component lines.
For example, in the below table the Type 1 License totals (top level of matrix) should only include Type 1 License Distributor and Supplier totals, and not the 'Other' (apologies for layout but obviously can't add a matrix here and can't share my pbix).
Obviously we could just add separate visuals and filter this out where needed, but this gets messy when cross-visual filtering.
How do we achieve this? Is there some smart option we have not thought of?
October 2022 | November 2022 | December 2022 | |
Type 1 License Totals | 1000 | 1100 | 1200 |
Type 1 License - Distributor | 800 | 900 | 1000 |
Type 1 License - Supplier | 200 | 200 | 200 |
Type 1 License - Other | 150 | 160 | 160 |
Solved! Go to Solution.
Hi, @Gingerjeans88
You can try adding filtering to your Page.
At this point, the View of the Other no longer appears on this page.
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Gingerjeans88
You can try adding filtering to your Page.
At this point, the View of the Other no longer appears on this page.
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You can make it dynamic,
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
@Gingerjeans88 Matrix Measure Total Triple Threat Rock & Roll - Microsoft Power BI Community
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 |