doughnut chart: top 3

[floralau]

What I have now is a doughnut chart with mainly two colors(i.e red and blue) and more than 10 values. and i would like to show the top 3 values of each color. or either to only show top 3 value's label.

Thank you!!

[PC2790]

You would need to create a meausre to get the top three values and then use that measure in the "Values" section of Donut chart.

You can use TOPN to get the top three values

TOPN function (DAX) - DAX | Microsoft Docs

[floralau]

Sorry, still a bit confused. 

testing2 = TOPN(3,'Succesful Rate', 'Succesful Rate'[Channel])

"Channel" include many things (e.g aaa, bbb, bbb, ccc)

May i ask what's wring with it?

[PC2790]

on what criteria you are basing your top three value?

I can give you an example, suppose I want the top three based on the sum of the amounts across each country. I'll use:

Top3 = sumx(TOPN(3,SUMMARIZE(CCY,CCY[CY],"abcd",SUM(CCY[Amount_in_USD])),[abcd],DESC),[abcd])

You can try to mould it according to your requirement.Or provide with more details on the dataset so that we cna help you with it

[floralau]

My [Channel] column is somethings like "aaa","aaa","bbb","ccc""ccc", "ddd","ddd","ddd","eee".

I would like to count them, and rank by the number of appearances.

Thank a lot for answering!

[PC2790 · Accepted solution]

See if this helps:

Measureabcd =
SUMX (
    TOPN (
        3,
        SUMMARIZE (
            ChannelTable,
            ChannelTable[Channel],
            "abcd", COUNT ( ChannelTable[Channel] )
        ),
        [abcd], DESC
    ),
    COUNT ( ChannelTable[Channel] )
)

[floralau]

Thanks so much for helping!