Concitional Formating each column in Matrix

[Anonymous]

Hi I have matrix and each column have a different color coding

example points < 50 = red , utilisation <40% = red

ho to do it ?

[v-luwang-msft]

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

[v-luwang-msft · Accepted solution]

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!

[amitchandak]

@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