Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

conditional formatting per column

I have a table which shows the number of car crashes for each car within with 3 columns - HIgh, Medium, low. I want to add conditional formatting to each cell. The conditions are  for the background...
Need Help
Show and Tell
Tips and Tricks
  • v-lionel-msft's avatar
    v-lionel-msft
    5 years ago

    Hi Anonymous ,

     

    Please refer to my .pbix file.

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-lionel-msft's avatar
v-lionel-msft
Community Support
5 years ago

Hi Anonymous ,

 

Try to use the feature.

 

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi there,

     

    Thanks this is very helpful.

     

    The issue is that the values are a measure, the columns are high,medium,low. these dont show up as options under the conditional formatting list.

     

    Cheers 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Here is the visual :

     

    notice how the columns are an option for conditional formatting? just the values for the table.

     

     

    • v-lionel-msft's avatar
      v-lionel-msft
      Community Support
      5 years ago

      Hi Anonymous ,

       

      Please refer to my .pbix file.

       

      Best regards,
      Lionel Chen

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.