I have a visual and i've inserted a chiclet slicer which represents the legend of the visual. There are three categories.
I want the three slicers to represent the legend colours.
Any idea how to do this?
Solved! Go to Solution.
Hi @Anonymous ,
Based on my test,I find that no setting of button color in chiclet slicer, so one workaround is that you could create a bar chart , then set conditional formatting in Data Color like my sample.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Based on my test,I find that no setting of button color in chiclet slicer, so one workaround is that you could create a bar chart , then set conditional formatting in Data Color like my sample.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I'm not sure it is possible. I don't think it has expression based formatting. As an idea, how about putting a colour box behind each button.
But I can't seem to make the chiclet transparent so you can't see the colour box in any case
Turn on the background and set it to 100% transparent
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
107 | |
74 | |
66 | |
49 | |
48 |
User | Count |
---|---|
164 | |
87 | |
77 | |
70 | |
67 |