Forum Discussion

Sjoerd_g's avatar
Sjoerd_g
Frequent Visitor
4 years ago
Solved

Conditional formatting continued on second visual

Hey all,   I have a Top and a Bottom 5 table for branches and their social review ratings.   I am using a DAX formula to have conditional formatting per matrix column (which does not work perfect...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    Hi Sjoerd_g 

     

    You should format the background color based on the exact Rating values rather than dynamic ranking values. Specify a pair of fixed minimum and maximum values (e.g. 0 and 5) for conditional formatting instead of using the default Highest and Lowest values. 

    This should work. 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

     

v-jingzhang's avatar
v-jingzhang
Community Support
4 years ago

Hi Sjoerd_g 

 

You should format the background color based on the exact Rating values rather than dynamic ranking values. Specify a pair of fixed minimum and maximum values (e.g. 0 and 5) for conditional formatting instead of using the default Highest and Lowest values. 

This should work. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.