Forum Discussion
Change bar chart column for 3 higher value
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
1 Reply
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
