conditional formatting

[Giada_Togliatti]

Hi,

I should apply a conditional formatting in a matrix

I shuold display color based on text string on another field.

I have a field that has this possible value: "High", "Medium", "Low", "Too much low"

High  must be coloured by red, medium by orange, low by yellow and too much low by white.

Field1 is not a measure, it's a string field.

How can I do the formula that I can use to color the matrix?

Thank you

[amitchandak]

@Giada_Togliatti , refer if these can help

Color Field - Color Measure - Conditional formatting
https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/
https://community.powerbi.com/t5/Desktop/FORMAT-icon-set-for-use-in-a-data-card/td-p/811692

[Giada_Togliatti]

@amitchandak thank you for the link, the problem that I have is that the field that contains the string is not a measure,

so I need to turn text column into measure because if it's the column I can't use in the formula, how can I  do that?

column contains the value I told before

[v-shex-msft]

Hi @Giada_Togliatti,

Can you please share some dummy data with the expected result to test? It will help to clarify your data structure and test to coding formula on it.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[MattAllington]

I have an article on my blog that explains this. https://exceleratorbi.com.au/conditional-formatting-with-a-text-field-in-power-bi/