Conditional formatting issue

Question

Hi all,&nbsp;I have generated the below table with two metrics.The Quality KPI switch =&nbsp;quality KPI switch = SWITCH(TRUE(),[Quality KPI] &lt; -0.1 , "G" ,[Quality KPI] &lt;= 0 &amp;&amp; [Quality KPI] &gt;= -0.1 , "A" ,[Quality KPI] &lt; 1 , "R" )&nbsp;&nbsp;I would like to apply&nbsp; conditional formatting with three different colors to the quality KPI column using the quality KPI figuresI want to apply the following rules to my formatting&nbsp;If Quality KPI is between 0 and - 10% --&gt; "A" and "Color1"If quality KPI is more than - 10% --&gt; "G" and " Color2"If quality KPI is more than 1% or any positiive value --&gt; "R" and "color2".&nbsp;I tried to add the colors into the switch function and also tried the conditional formatting but did not manage to get the expected results&nbsp;Can anyone please help me achieve this or at least guide me on how i can get it done ?&nbsp;Thanks in advance&nbsp;&nbsp;&nbsp;&nbsp;

amitchandak · Accepted Answer

Mous007 , a color measure like given below can used in conditional formatting with field value option
&nbsp;
quality KPI color = SWITCH(TRUE(),[Quality KPI] &lt; -0.1 , "Green" ,[Quality KPI] &lt;= 0 &amp;&amp; [Quality KPI] &gt;= -0.1 , "Yellow" ,[Quality KPI] &lt; 1 , "Red" )
&nbsp;
&nbsp;
refer for steps
https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-columnhttps://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values

Forum Discussion

Conditional formatting issue

2 Replies

Related content

Conditional Formatting

Conditional Formatting using DAX

Conditional Formatting

Matrix Row Conditional Formatting

Condition formatting