Forum Discussion

Charu's avatar
Charu
Icon for Post Patron rankPost Patron
8 years ago
Solved

Conditional Formatting for specific field value in power bi desktop

Hi All,   Using conditional formatting I want to display the score of the user whether he achieved or not so that by colors. For example: Target is 5 and I have scored in the range of 0,0.05,0.78....
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi Charu,

     

    Yes that would indeed be the best solution but if I am not mistaken conditional formatting is at the moment only possible for the "Table" and "Matrix" visual so that is the reason I presented you with this workaround. 

     

    Best regards,

    L.Meijdam

     

Charu's avatar
Charu
Icon for Post Patron rankPost Patron
8 years ago

Yeah, I want to display score based on the player filter and I need to bring the color like if the score is less than 10 Red and greater than 10 Green.

 

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Charu,

 

I think this is possible with the "KPI visual" Please look at the examples below. (Note the target in the example is 5 not 10 but you can make it whatever you want)

 

I made a second table which I named "Target" the table looks like this:

Target
5.00

 

Example 1Example 2

This is not exactly the way you are supposed to use this visual but I couldnt think of another solution, I hope this works for you.

 

Best regards,

L.Meijdam

  • Charu's avatar
    Charu
    Icon for Post Patron rankPost Patron
    8 years ago

    Hi Anonymous

     

    Thanks a lot.

    This solution may help me in future.

     

    But I expect conditional formatting where we can give our conditions!...

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi Charu,

       

      Yes that would indeed be the best solution but if I am not mistaken conditional formatting is at the moment only possible for the "Table" and "Matrix" visual so that is the reason I presented you with this workaround. 

       

      Best regards,

      L.Meijdam

       

      • Charu's avatar
        Charu
        Icon for Post Patron rankPost Patron
        8 years ago

        Thanks for your timely help :smileyhappy: