Forum Discussion

QuasemS's avatar
QuasemS
Frequent Visitor
10 years ago
Solved

Color based on number value

Hi,

 

I am trying to create a table like this:

 

 

But when I create a table, I can't seem to get the color to show based on the value. Basically I want the same thing which goes from 0-100 and red to green. I couldn't find any thresholds where I can set colors or anything in the table visual.

 

Does anyone know how to achieve this?

 

Thanks!

Need Help
  • QuasemS's avatar
    QuasemS
    10 years ago

    That screnshot has actually been taken from Power BI, and I figured out how to do it. It's called 'conditional formatting' and can be found in the drop down menu for 'fields'

3 Replies

  • Totte67's avatar
    Totte67
    Frequent Visitor
    10 years ago

    I have also look´t on this and what I have seen,
    you can not get that in Power BI yet, like you have in Ecxel,
    but what I read it will come sone,
    I hope:-)
    You have a Visiual that can get you a card with color "Card with States by SQLBI"

     

    Best regards

    Totte67

    • QuasemS's avatar
      QuasemS
      Frequent Visitor
      10 years ago

      That screnshot has actually been taken from Power BI, and I figured out how to do it. It's called 'conditional formatting' and can be found in the drop down menu for 'fields'

      • Totte67's avatar
        Totte67
        Frequent Visitor
        10 years ago

        Thanks, then I also got the solution :-)
        It look´s like Excel but now when I looked at it again I saw it was in Power BI.

         

        Best regards

        Totte67