Top 10 Sales for the Year Donut Chart - Keep total sales percentage

[MP-iCONN]

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.

[v-yangliu-msft · Accepted 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

[amitchandak]

@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