Use doughnut/guage chart to calculate ranks

[Saloni]

Can I calculate ranks dynamically by using a doughnut/guage chart?

For eg. I have a list of 10 companies. I select any 5. I want my chart to show the rank of a particular company as compared to the median.

Appreciate your help!

[v-huizhn-msft]

Hi @Saloni,

In doughnut/guage chart, you select any 5? It's confusing. Based on my understanding, you can create a slicer, you will rank value based on slicer? If it is, you can refer to this similar thread, which gives the details.

If this is not, please post sample table for further analysis. I really understand your data is private, you can create same fake sample data, so we can post solution  which is close to your requirement.

Best Regards,
Angelia

[Phil_Seamark]

Hi @Saloni

Any chance you can post a small sample set of mock data along to help show what you mean.  It sounds easy enough. 🙂