Forum Discussion
List Slicer Callout Values Conditional Color
I am creating a list slicer with conditional color implemented on callout values. It is working just fine, also when opened in Fabric. However, whenever I open the report again in Power BI Desktop conditional formatting is reset, and I need to set it up again. I tried applying it using setting for "All", for specific Action, using Advanced Settings, and problem remains.
Hi MariBely
Hmm I've tried recreating the issue and it seems to work.
Couple of things to try:
Delete the visual and recreate (Don't copy paste) - sometimes visuals randomly breakUse Basic conditional formatting - list slicer is still in preview so might have bugs
Try a simpler measure with a basic IF - could be the measure returns a different value at diff times, if it ever returns a non text value it will be turned off
I've also had issues with data sources like SQL when the output is random, column would be called one thing one thing but contain the data of another on every refresh.
There are a couple of custom visuals you could use if it doesn't work:
6 Replies
Hi MariBely,
When you say "conditional formatting is reset" do you mean any filters you have applied via slicers have reset or the actual conditional formatting settings have been removed?
In Power BI Service there is a settings called "Persistent filters":
This means that when a user (including the editor in Reading view) applies a filter that is saved.
You can see the filter being applied in the browser by this icon:
Clicking the reset icon will remove the filter.
There is no equivilent in Power BI Desktop per say. If you apply filters and then save the Pbix file then it should be there when you next open it. You could also capture a Bookmark in the Desktop version and that would save the filters.
If its the Latter and all the conditional formatting settings are disapearing then that is odd! Can you share a file that has the issue in it?
Hi, thanks for your answer, but persistent filters are not the solution here. I am using a measure to determing conditional formatting of Callout Values in New List Slicer:
Whenever I close and open the file again "fx" getst reset to a default color.
Hi MariBely
Hmm I've tried recreating the issue and it seems to work.
Couple of things to try:
Delete the visual and recreate (Don't copy paste) - sometimes visuals randomly breakUse Basic conditional formatting - list slicer is still in preview so might have bugs
Try a simpler measure with a basic IF - could be the measure returns a different value at diff times, if it ever returns a non text value it will be turned off
I've also had issues with data sources like SQL when the output is random, column would be called one thing one thing but contain the data of another on every refresh.
There are a couple of custom visuals you could use if it doesn't work:
