Forum Discussion
stitch_es
2 years agoFrequent Visitor
Conditional Formatting being removed when using Row Level Security
Hi - Hope someone on here can help me. I have a simple report that shows logs per user on a daily basis. The idea is to highlight when they skipped a day (or days) of logging in. My code has the c...
- 2 years ago
Hi - Thank you so much for responding.
When cleaning up the file to share with you, I was making my DirectQuery all into Direct Import mode so that the pbix wouldn't need to connect to the db. Then it worked and the formatting stayed the same. Is there something with Direct Query that would prevent the conditional formatting to carry over when being filtered? The value that it is using to determine the formatting does not change - see below:
all data:
using RLS:
amitchandak
Super User
2 years agostitch_es , can you add the value on the visual, in which conditional formatting is done? I doubt that is also changing here.
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.