Forum Discussion

MelissaL-ERGT's avatar
MelissaL-ERGT
New Member
2 years ago
Solved

Conditional Formatting on a bar chart. Not working when a filter from another visual is applied

Hello,   I am after some help please on conditional formatting. My data set is for a team assessment score. It is a % and is made up on 6 different attributes. The chart i am trying to conditiona...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi MelissaL-ERGT ,

    Agree with danextian, you can't achieve this by highlight even change your DAX.

    Highlight is different from filter and slicer, its role is only to make the whole report all the data related to the content you clicked to highlight, and other data not related to it is not filtered out but just fade out the display, so in this case you set the Conditional format corresponding to the data is still all the data instead of the In this case, the data in the Conditional format you set is still all the data, not just the FTA Team data.

    I suggest you add a slicer or use the filter that comes with the report instead of clicking on a name in the table to highlight it as the filter.

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