Forum Discussion
Concitional Formating each column in Matrix
Hi I have matrix and each column have a different color coding
example points < 50 = red , utilisation <40% = red
ho to do it ?
Hi Anonymous
You could create a measure like below:
Measure Value Color = IF(MAX('Table'[Point])<=50,"#ff0000","#000000")
Then:
Then you will see:
More about how to configure color measure,you can see the below:
https://community.powerbi.com/t5/Desktop/Colour-formatting-on-Measure/m-p/864818#M414953
Wish it is helpful for you!
3 Replies
Anonymous , You can create a color measure and do it. The measure can check for measure value or dimension value
example
Color sales = if(AVERAGE(Sales[Sales Amount])<170,"green","red")
Color Year = if(FIRSTNONBLANK('Table'[Year],2014) <=2016,"lightgreen",if(FIRSTNONBLANK('Table'[Year],2014)>2018,"red","yellow"))You can refer to my video for more details: https://www.youtube.com/watch?v=RqBb5eBf_I4
Hi Anonymous
You could create a measure like below:
Measure Value Color = IF(MAX('Table'[Point])<=50,"#ff0000","#000000")
Then:
Then you will see:
More about how to configure color measure,you can see the below:
https://community.powerbi.com/t5/Desktop/Colour-formatting-on-Measure/m-p/864818#M414953
Wish it is helpful for you!
Hi Anonymous ，
Has your problem been solved, if so, please consider Accept a correct reply as the solution to help others find it.Best Regard
Lucien Wang
