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 everyone.
Please help with the following task - there is a table with a list of indicators, such as products, and a field with dates and amounts. It is necessary to create a measure that, in visualization, would display only those products that make up more than 10% of the total amount. Products under 10% should be displayed as "Other" in the total amount row. Importantly, the measure should dynamically achieve this.
I have created an example measure in the attached file, but for some reason, it does not display the "Other" row, which is in the reference.
Please let me know if you can offer any assistance. Your help would be greatly appreciated.
https://drive.google.com/file/d/1KL_GQFWRQaqhYmrX_PZ44oJXlBt602py/view?usp=sharing
Sorry, please try now.
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 |
---|---|
110 | |
109 | |
88 | |
76 | |
66 |
User | Count |
---|---|
126 | |
112 | |
99 | |
82 | |
73 |