Forum Discussion
How do I Enable New Matrix Visual Preview?
Hi kritip,
Follow below steps:
1. Create Matrix visual.
2. Add your fields in Rows/Columns, however, you wanna design.
3. Add measure in Values field.
4. Right click on measure, you will see Conditional Formatting option.
Refer this link for more details. Conditional formatting is done in same way for tables as well.
Prateek Raina
Thanks it works, i am able to see the option now but unfortunately it doesn't solve my requirements :(
I have the below matrix and I am looking to set the backgroud color of the cells based on the calculated values as shown below. So for cell with Orange value I would like the cell to be of Orange color.
Is there an option to do that in Power BI?
Hi kritip,
We have an option called Background color scales in Condition formatting. You will be able to set the maximum of three colors. The limitation from your requirement is, you have text values. The option provides two scenarios to apply the background color,
- Lowest and highest values
- Static numbers
There is no option for apply background color based on the text values.
I hope I made it clear.
Regards,
Siva
Thanks for clarifying..I'll try to update my matrix to have static numbers instead of text but even in that case I'll have to create a Measure and I'll only be able to set color for 3 numbers and not more than that, right? Is there a way to achieve this (for more values) via some other visualization?
