I am comparing my product’s market share with that of top 5 in the industry in 1 column chart. However, I’m unable to do this and need some help. I have tried using the Top N filter on PowerBI, but this only gives me Top 5 but I cant bring my company’s results in if it isnt in top 5. Is there any way I can do this?
What I have:
Table of Market Values by Company. e.g.
| Company Name | Market Cap |
|---|---|
| Pears | 2.1T |
| Oranges | 1T |
| Bananas | 0.9T |
| Grapes | 0.9T |
| Watermelon | 0.8T |
| …….. | 0.7T |
| …….. | 0.6T |
| Mangoes(my company) | 0.2T |
What I need is to display the Top 5 in the industry(up until Watermelon above) as well as my company (Mangoes) on 1 column chart with market size being the measure of Company Market Cap/Sum of all companies’ market cap.
Thank you