Forum Discussion
Conditional Formatting Slicer Background BUG
I find a bug in the operation of conditional formatting to change the background to a slicer in power bi.
With the same measure, all slicers except the one that "activates" the measure work. But the first one should also work.
Why?
12 Replies
You can use the Report an Issue link at the bottom of the page here to post it:
https://powerbi.microsoft.com/en-us/support/free/
Hi,
I have a similar, although not exactly the same issue.
I have 52 slicers in a report. all with a similar color coding measure:
I have only testied with 3 so far.
The measures are
_IsSelectedProduct=IF(ISFILTERED(TableName[Product] ),"#00FFFF","#FFFFFF")
_IsSelectedStatus=IF(ISFILTERED(TableName[Status] ),"#00FFFF","#FFFFFF")
_IsSelectedFileType=IF(ISFILTERED(TableName[Filetype] ),"#00FFFF","#FFFFFF")
When I apply to the slicers background, the strangest things happened.
I started with Status, applied the slicer measure in the Fill format, it worked.
Moved on to the next (FileType), Applied the mesasure for that one, it didn't work. I check my measure calcualtion and it worked fine in a card.or on a shape.
Changed the measure for the FileType slicer to use the Status measure instead. It worked: if a value is selected in the Status slicer, the file type slicer changes color.
Removed all conditional formatting, and reapplied. None of them works now...
I am assuming it is a bug. I tried to report it using the link above, but although it says "Issues" on top of the page, it looks like you can only submit ideas...
Any advice?
Thank you.
Hi,
does the measure work if you just use = on the conditional formatting rather than > and <=?
