Forum Discussion
Top N color
Hello,
I am wondering how to do coloring on Top N values.
Can anyone suggest on this?
2 Replies
- amitchandak
Super User
Anonymous , You can create a TOPN measure and the can a color mrausre
example
TOPNM= calculate([Amount], ,TOPN( 10,allselected(Table[Axis Column]),[Amount],DESC), values(Table[Axis Column]))
COlor meausre=
Swich(True(),
[TOPNM] <=3, "Green",
[TOPNM] <=5, "Orange",
[TOPNM] <=10, "Red")
and use that in conditional formatting using field value option
Conditional formatting the Pie Visual: https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/1682539
