Forum Discussion
conditional formatting in matrix based on a different text field
Hi All, I have a measure that converts text values -completed/ in-progress/ expired- which are stored in a field, to nummbers- 0 or 1. I am then using this measure to create a matrix in PowerBI. I w...
Hello sjain6,
Lucky you, there is a simple trick to work around the limitation. You can use conditional formatting on value columns in matrices having a numeric value. Therefore you need a measure or field, which will be used for this column.
- Convert the text status field into numbers. Better to use a field instead of a measure, but that's not that important. So you have 0 for "expired" and null for the rest
- Add the new field to the matrix
- Set up conditional formatting on this field. E.g. use background color scales for ranges. There set the conditions to match 0 with the desired color.
And that's it.
See the example below:
Hello Anonymous,
Would you be able to post your sample as a file? I am in need of something similar and couldn't figure out what you meant. Probably just some terminology I'm not used to.
Thanks
Goppi
