The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Is there a way to have a Donut Chart in Power BI that will show the Top 10 sales by Year, showing that dollar amount for each customer, but keep the percentage of total sales across all customers shown rather than just the percentage of the Top 10 shown in the chart?
Thank you.
Solved! Go to Solution.
Hi @MP-iCONN ,
I created some data:
Here are the steps you can follow:
1. Find Drill Down Donut via More Visual.
2. Create measure.
Group_Sum =
DIVIDE(
CALCULATE(
SUM('Table'[Amount1]),FILTER(ALL('Table'),
'Table'[Year]=MAX('Table'[Year])&&'Table'[Group]=MAX('Table'[Group])))
,
CALCULATE(
SUM('Table'[Amount2]),FILTER(ALL('Table'),
'Table'[Year]=MAX('Table'[Year])&&'Table'[Group]=MAX('Table'[Group]))))
All_SUm =
DIVIDE(
SUMX(ALL('Table'),
[Amount1]),
SUMX(ALL('Table'),
[Amount2]))
rank =
RANKX(FILTER(ALL('Table'),
[Year]=MAX('Table'[Year])),[Group_Sum],,DESC)
Flag =
IF(
[rank] <=10,1,0)
3. Place [Flag]in Filters, set is=1, apply filter.
4. Result:
You can choose which Year to display the specific Group information of this Year.
Click 2020 to display the data of the top 10 in 2020.
If you need pbix, please click here.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @MP-iCONN ,
I created some data:
Here are the steps you can follow:
1. Find Drill Down Donut via More Visual.
2. Create measure.
Group_Sum =
DIVIDE(
CALCULATE(
SUM('Table'[Amount1]),FILTER(ALL('Table'),
'Table'[Year]=MAX('Table'[Year])&&'Table'[Group]=MAX('Table'[Group])))
,
CALCULATE(
SUM('Table'[Amount2]),FILTER(ALL('Table'),
'Table'[Year]=MAX('Table'[Year])&&'Table'[Group]=MAX('Table'[Group]))))
All_SUm =
DIVIDE(
SUMX(ALL('Table'),
[Amount1]),
SUMX(ALL('Table'),
[Amount2]))
rank =
RANKX(FILTER(ALL('Table'),
[Year]=MAX('Table'[Year])),[Group_Sum],,DESC)
Flag =
IF(
[rank] <=10,1,0)
3. Place [Flag]in Filters, set is=1, apply filter.
4. Result:
You can choose which Year to display the specific Group information of this Year.
Click 2020 to display the data of the top 10 in 2020.
If you need pbix, please click here.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
@MP-iCONN , I saw this video today, see if this can help(it is youtube shorts, vertical- but have info)
Change Data labels
https://www.youtube.com/watch?v=un4PkoGF3YM
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
101 | |
94 | |
80 | |
63 | |
56 |
User | Count |
---|---|
247 | |
122 | |
110 | |
77 | |
72 |