Forum Discussion

kritip's avatar
kritip
Frequent Visitor
8 years ago

How do I Enable New Matrix Visual Preview?

I would like to use the New Matrix Visual Preview feature and I refered to this link - https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-matrix-visual/ - to see how i can enable it bu...
Reports
kritip's avatar
kritip
Frequent Visitor
8 years ago

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?

 

 

SivaMani's avatar
SivaMani
Resident Rockstar
8 years ago

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,

  1. Lowest and highest values
  2.  Static numbers

There is no option for apply background color based on the text values.

 

I hope I made it clear.

 

Regards,

Siva

  • kritip's avatar
    kritip
    Frequent Visitor
    8 years ago

    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?

    • SivaMani's avatar
      SivaMani
      Resident Rockstar
      8 years ago

      kritip

      In my best of knowledge,

      There is no option to set the background color (more than 3) based on some condition.