Forum Discussion

Mattiar's avatar
Mattiar
Resolver I
3 years ago

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. B...
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.