Conditional Formatting Removed With Date Filter

[Anonymous]

Hello,

I have conditional formatting applied on a visual matrix based on the sum of certain quantities. The cells are highlighted if there is a change in the sum across two consecutive dates. However, the formatting disappears when I apply a date filter, the formatting disappears. I have no idea why this is happening, please help!

[v-yingjl]

Hi @Anonymous ,

How did you define the rule of conditional format and apply the date filter? Could you please consider sharing more details about it for further discussion?

In addition, you can add tables in the community with the sample data or some screenshots about it if you could not attach the sample file.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , what kind of conditions you have, are you getting a different range of values than you have configured. or are you getting null values.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4

[Anonymous]

@amitchandak so I am getting the same values, just the formatting is removed. You can see before and after applying the date filter:

[Anonymous]

@amitchandak Could you please send me your email, I'll share the files there after removing the data. I am not able to send messages on Power BI for some odd reason and am really stuck on this