Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
I got sales amount by state. I would like to heigh light the top 3 states by sales amount. Which visual should I use?
Solved! Go to Solution.
Hi @Anonymous ,
I think histogram is more suitable, such as stacked column chart.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Most visuals can be used, because the TOP 3 results have nothing to do with the visual, you only need to operate in the Filters.
Here‘s a simple example,
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You can check more details from the attachment, or you can kindly refer to the official document.
Hi Stephen,
Thank you for your comment.
I agree there are lots of visuals can be use to visualize top 3. My question was which visual/visuals is more suitable.
Thanks
Hi @Anonymous ,
I think histogram is more suitable, such as stacked column chart.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
Understand you know how to find the 3 top values [If not, read @amitchandak post below ]
so please see this link:
https://docs.microsoft.com/en-us/power-bi/visuals/service-tips-and-tricks-for-color-formatting
you also can use conditional formatting:
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos ✌️!!
@Anonymous , Create a TOPN measure , you can use that in pie, bar or any visual you like
calculate([total medal medlist],TOPN(3,allselected(Table[ID]),[total medal medlist],DESC), values(Table[ID]))
refer
TOPN: https://www.youtube.com/watch?v=QIVEFp-QiOk&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=42
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!