SHOW LABEL ONLY ON TOP N ITEMS

[jbang]

Good day everyone, 

I would like ask if anybody can help me to solve the problem below. 

I have created a donut chart with several items, and I would like to label only on TOP 5 items, so that those label could be displayed without being clipped.

Anyone has gone through this matter?? 

I really appreciate it, thanks! 

[Arul]

@jbang ,

Have you tried visual level filter TOP N, refer the image below.

Thanks,

Arul

[jbang]

Hello Arul, thank you for your response! 

But the thing is that I want to display all the items in a donut chart and only show the labels of the TOP 5 items out of the total items. 

Could you help me on this matter please? 

Thank you!

[Arul · Accepted solution]

@jbang ,

Can you write a measure? For the value what you are trying to showing up create a measure and then use it colors conditional formattiong(fx) of values as a Rules, wherein rules for 1 please provide the color that matches the visual background and then for 0 provide the color you want the labels to display.

Rank segment = 
VAR _rank = RANKX(
   ALL(financials[Segment]),
    [Sales Test],,DESC,Dense)
VAR _result = IF(_rank>3,1,0)
RETURN _result

Thanks,

Arul

[jbang]

IT´S AMAZING!! 

It works !! Thank you so much!

Have a wonderful day!