Change bar chart column for 3 higher value

[Anonymous]

Hi guys, 

I have a bar chart that represent risks. 

I want to change the color for the 3 higher risk where the value is the most elevated. 

I don't want to change color based to static value like >100 but by 3 top higher values of my chart 

How can i do this?

• Many Thx for help 

[themistoklis]

@Anonymous 

First create a measure which identifies the top N values. Check following 2 links on how you can achieve that.

https://www.sqlbi.com/articles/filtering-the-top-3-products-for-each-category-in-power-bi/

https://databear.com/power-bi-dax-topn-function/

If you have a clustered column chart then go to 'Data Colors' and click the fx button next to 'Default Color'

On the pop up screen select 'Format By': Field Value

Then select the measure that you created previously. See image below