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... 

 

So I need to indicate my score in red color and Target in Green color. I just want to display only that column, not other columns.Please help me how to achieve this

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

     

9 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

     

    Hi Charu,

     

    Here are the step I took to solve your problem:

     

    Data used is:

    UserScore

    Brian0.67
    Carl2.45
    Sean5.2
    Rick7.75

     

     Step 1Step 2

    Step 3Step 4

    If you have any further questions or if this is not exactly what you wanted please let me know :)

     

    Best regards,

    L.Meijdam

     

     

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

      Hi Anonymous

       

      In Table Visual I could achieve this, I need the same in the card visual.is there any custom visual where it accepts conditional formatting?

      please guide me

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Hi Charu,

         

        What exactly do you want the card to display the average of all the scores ? Since a card can only display one score.

         

        Best regards,

        Lieuwe Meijdam