Forum Discussion
Single Legend for multiple visuals?
Hi Mk60 ,
Thanks again for following up! you are right .The Matrix visual doesn’t support cell-level conditional formatting, which is why that black dot still shows up.
The Table visual does allow individual cell formatting, which is why the color blends work better, especially with the dot or space trick. If you prefer an even cleaner look (without any dot at all), try using a space " " in a column[ColorBox = " "] and apply background color conditional formatting ,that gives you simple color boxes, much like a native legend. I totally get that the Table layout may not be your ideal setup, but this is currently the closest way to fully control the legend style in Power BI.
The output is looks like:If my response helped you to reslove the query,consider acepting it as solution.
Regards,
Pallavi.
Hi Mk60 ,
Thanks again for following up! you are right .The Matrix visual doesn’t support cell-level conditional formatting, which is why that black dot still shows up.
The Table visual does allow individual cell formatting, which is why the color blends work better, especially with the dot or space trick. If you prefer an even cleaner look (without any dot at all), try using a space " " in a column[ColorBox = " "] and apply background color conditional formatting ,that gives you simple color boxes, much like a native legend. I totally get that the Table layout may not be your ideal setup, but this is currently the closest way to fully control the legend style in Power BI.
The output is looks like:
If my response helped you to reslove the query,consider acepting it as solution.
Regards,
Pallavi.
Thanks much for the space " " tip, I'll definitively test that. I assume it will give me the same final outcome with collored boxes as I got using Button slicer visual, but with your suggestion I can have metric names on the top of each color, making it look like actual legend. Thanks a lot again for your time and collaboration on this, Pallavi. Much apprecited!
Marin