Conditional Formatting not working when a filter is applied

[cmorris_afca]

Hello,

I have created a two cards and added conditional formatting to the 'data label' and 'title' so that they are black or white depending if they should be visable or not, this allows me to overlay the visuals and display one or the other depending on a value that is selected on a slicer.

I then have a need to apply a filter to the visual and the results in the conditional formatting not working, so I see both cards together.

Does anyone know why this happens? Why is the filter stopping the conditional formatting?

Regards,

Carl

[V-lianl-msft]

Hi @cmorris_afca ,

Based on your description, you want one card to cover another, and when you filter through slicer, the corresponding value will be displayed.

You can refer to this blog:
https://exceleratorbi.com.au/show-or-hide-a-power-bi-visual-based-on-selection/ 

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

[cmorris_afca]

Hi,

I have tried that and it works fine when there is no filter applied and the user selects the requirements via the slicer.

The issue is I have a large set of data that comes into my model and depending on the card, a filter needs to be applied so that only the required figures are displayed. The user then uses the slicers to select the required month/user/team. These work fine seperatley but when I have both a filter (which is static) and a slicer the conditional formatting does not work.

Regards,

Carl

[V-lianl-msft]

Hi @cmorris_afca ,

It may be difficult to fully meet your needs.

Could you please share sample pbix and DAX formula? We can think about other alternatives.

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

[amitchandak]

I am hopeful, that the new value of cart/color formatting filed, after filter is, covered under conditional formatting. Can you share calculation and foamtting rules.