Conditional Formatting in the Matrix

[stribor45]

I am trying to put some background colors in the values of my matrix. I have column called "Achieved" with following values

123.44%

87.22%

146%

which means 

23.44 above the target

12.78 below the target

46% above target

i would love to put background color green on the ones above the target and red on the values eblow the target however I am not succesfull. I feel like it has to do something with my formating as this is formatted as percentage with 2 number of spaces.  I want to preserve that value is show as is.

Thanks

[v-venuppu]

Hi @stribor45 ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @DaleT for the prompt response.

I wanted to check if you had the opportunity to review the information provided and resolve the issue..?Please let us know if you need any further assistance.We are happy to help.

Thank you.

[stribor45]

just to be sure, Are you saying that this (yellow) circle can not take conditional formating?

[DaleT · Accepted solution]

They are the subtotals (totals). They can be colored. Like below enable it in the settings:

[DaleT]

Hi,

Please refer the image below. Using the Rules should work.

[stribor45]

That worked i just dont understand whyn these numbers work. between -1000 < 1 red. Why does this work?

Also can this conditional formatting be applied to row headers as well?

[DaleT]

Firstly, I recalled something that -1000 isn't necessary. We can use the built-in method as showing in the following image. Secondly, we can understand it this way: the conditional rules will iterate the value row by row. 123.44% is 1.2344 and it is greater than 1, then the background is green. The same logic for other values. Hope this helps. I am afraid we can't apply the background color to the header. Becuase the header is string other than numbers.