Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

PavelHanus

slicer background color based field vale

Submitted by on ‎05-19-2022 08:02 AM

Hi 

i have an issue to format slicer background color based on selecting value in the same slicer. Using measure with IF and ISFILTERED function in background color. (more info in pic below) It is not changing as expected

 

When I copy the visual it works fine (it works for other visuals excepts "home" one)

 

see at the picture bellow.

 

Pavel

PavelHanus_0-1652972482250.png

 

Status: Delivered

Update:

It is by design in Power BI. Slicers don't filter themselves. If they did, as soon as you selected one value, all the other choices would disappear. When you copy and have a second slicer, then that second slicer filters the first one, but it also removes all the other options. 

 

To achieve what you want, consider a Rect Shape object with conditional Fill color, underneath the slicer, and make the slicer background transparent. Make sure to use Count (distinct) as the summarization for your Rules

 

Best Regards,
Community Support Team _ Yingjie Li

See more ideas labeled with:
2 Comments (2 New)
Comments
v-yingjl
Community Support
Community Support
‎05-19-2022 08:03 PM
Status changed to: Accepted

Have sumbited this issue internal to confirm(ICM: 309003853), would update here as soon as possible if there is any progress about it.

 

Best Regards,
Community Support Team _ Yingjie Li

v-yingjl
Community Support
Community Support
‎05-24-2022 07:26 PM
Status changed to: Delivered

Update:

It is by design in Power BI. Slicers don't filter themselves. If they did, as soon as you selected one value, all the other choices would disappear. When you copy and have a second slicer, then that second slicer filters the first one, but it also removes all the other options. 

 

To achieve what you want, consider a Rect Shape object with conditional Fill color, underneath the slicer, and make the slicer background transparent. Make sure to use Count (distinct) as the summarization for your Rules

 

Best Regards,
Community Support Team _ Yingjie Li

Idea Statuses