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 want to visualise my data in in TopN format. I want want to rank Top 5 Company by is sum of its sales in each class.
Since there are lots of different companies in my data, I only want to show top five company in my visual but still show its percentage in based on total sales.
If I filter it by top N to show top5 the visual add up to 100% with just top5 companies therefore its actual percentage of the sale changes.
I want to display the ranking of the companys by each classes and present data in right percentage.
Hope it make sense. Thanks
Solved! Go to Solution.
Hi,
You may download my PBI file from here. Since your data is very less, i have show Top 2 Companies in every Class. The % is calculated as the total revenue of all companies in the Class (see Class 7).
Hope this helps.
Hi,
Please show the expected result.
Hi Ashish, below is the type of representation I want. so it shows top5 comanies each class and its market share.
Thanks
Hi,
You may download my PBI file from here. Since your data is very less, i have show Top 2 Companies in every Class. The % is calculated as the total revenue of all companies in the Class (see Class 7).
Hope this helps.
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 |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |