Forum Discussion
Background color based on slicer value
Hi - I am using below slicer and I need to show background color as below . Please share thoughts or alternate ways to represent the slicer with these values and colors
0-20 red
21-70 yellow
71-100 green
8 Replies
- dcrosseto
Resolver II
msft-cap , this approach only fixates a "border" outside of the slicer, you can change the black color when selected but not based on a condition. The colors have nothing to do with the slicer, that's what I'm trying to explain.
This solution is quite a pain because you have to adjust the sizing until fits, I don't have the exactly .pbix because I closed without saving, but I kinda replicated the scenario to help you replicate and see if fits to your necessity.
If it was helpful, please mark as solution to help others.
https://drive.google.com/file/d/1Hk76txJaFnLcSmu8xdgQfZkbcCSTYVYI/view?usp=sharing
Regards,
Douglas.
- v-chenwuz-msft
Community Support
Hi msft-cap ,
Maybe you can try bookmarks in power bi
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- msft-cap
Helper II
v-chenwuz-msft could you elaborate on the solution? this is what I would like to represent on the report.
- dcrosseto
Resolver II
Hi,
I'm afraid you cannot do that, the conditionals works only for all or none boxes, example all red backgrounds or all green border color and so on.One similar thing you could do is insert a shape at the background.
Hope it's helpful.
Regards,
Douglas.
- dcrosseto
Resolver II