Forum Discussion
Conditional Formatting in the Matrix
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
They are the subtotals (totals). They can be colored. Like below enable it in the settings:
6 Replies
Hi,
Please refer the image below. Using the Rules should work.
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?
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.
just to be sure, Are you saying that this (yellow) circle can not take conditional formating?
They are the subtotals (totals). They can be colored. Like below enable it in the settings:
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.
