Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!

0

Conditional Formatting Slicer Background BUG

Status: Delivered

Hi @Mattiar ,

It's not an actually "bug". For the Origin City slicer itself, despite we select an item in the slicer, it still have many items selectable, so it consider values(Origin City)=2058(which is the total distinct Origin City). 

vyanjiangmsft_0-1681107153156.png

To confirm this, I modify the conditional formatting rule of the Origin City like this:

vyanjiangmsft_2-1681107655016.png

Get the result:

vyanjiangmsft_3-1681107693772.png

If we save a copy of Origin City slicer and select the item at the same time, the slicer will only have one item seletable, this time it will display the expected color.

vyanjiangmsft_4-1681107812936.png

As a workaroud, I insert a blank button send back to the Origin City, set conditional formatting to the button, and set the Transparency of the slicer to 100%.

vyanjiangmsft_5-1681108080001.png

Get the expected result:

vyanjiangmsft_6-1681108165888.png

vyanjiangmsft_7-1681108191921.png

Best regards,

Community Support Team_yanjiang

 

Comments
v-yanjiang-msft
Community Support
Status changed to: Delivered

Hi @Mattiar ,

It's not an actually "bug". For the Origin City slicer itself, despite we select an item in the slicer, it still have many items selectable, so it consider values(Origin City)=2058(which is the total distinct Origin City). 

vyanjiangmsft_0-1681107153156.png

To confirm this, I modify the conditional formatting rule of the Origin City like this:

vyanjiangmsft_2-1681107655016.png

Get the result:

vyanjiangmsft_3-1681107693772.png

If we save a copy of Origin City slicer and select the item at the same time, the slicer will only have one item seletable, this time it will display the expected color.

vyanjiangmsft_4-1681107812936.png

As a workaroud, I insert a blank button send back to the Origin City, set conditional formatting to the button, and set the Transparency of the slicer to 100%.

vyanjiangmsft_5-1681108080001.png

Get the expected result:

vyanjiangmsft_6-1681108165888.png

vyanjiangmsft_7-1681108191921.png

Best regards,

Community Support Team_yanjiang

 

Mattiar
Resolver I

Hi @v-yanjiang-msft

You went into a lot of detail and for that I Thank You.

You convinced me on the speech that it is not really a bug but I remain of the idea that this behavior should be updated as it is misleading.

 

In any case, you have been very clear so I consider the question closed. Thanks again.