Forum Discussion
Conditional Formatting on a bar chart. Not working when a filter from another visual is applied
- 2 years ago
Hi MelissaL-ERGT ,
It appears that the behaviour of conditional formatting in cross-highlights is by design which, for me, doesn't make sense. https://community.fabric.microsoft.com/t5/Desktop/Cross-highlight-does-not-work-on-Conditionally-formatted-bar/td-p/2735896
- Anonymous2 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.
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.