Forum Discussion
Colour coding in matrix based on different column
Yes you can. When setting up the conditional formatting, simply select a different field under the option "Based on Field". If you do not see this option, make sure you are using an up to date Power BI Desktop.
The Power BI service should show this option.
Hi
Thanks for your response. I only see one field that I can select the Count and not the "Bucket" field which I need.
i'm using RS Version: 2.61.5192.641 64-bit (August 2018)
Is that an old version?
It is yes, although the feature should exist in your version. What you need to do is find the value column that you want the colour to exist in. Click its drop arrow and select Conditional Formatting. Inside that window will be the "Based on Field" option that will allow you to specify what the conditions are to colour your results in the matrix. In my example below, OPH is in my matrix and i've specified rules around OPH, however you could select with the dropdown, any other field in your model