Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
03-10-2017 09:58 AM - last edited 03-10-2017 11:41 AM
Thank you for sharing the multiple themes Amanda. Custom themes will be helpful.
Can you help me understand the following:
1. In your example, the treemap grouping (color) is by brandname, and bar chart legend (color) is Subcategory. As both the treemap and bar chart use use the "Power View Theme 1" the brandname and Subcategory have same colors (that is Contoso brand, and Computer Accesories sub category are in the same shade of blue). This is misleading. Only the same dimension value should have the same color for all charts/visualization on a dashboard/report. A different dimension needs to have a different color (or at least a different distinguishable shade). Is there any way that Power BI can have multiple unique color palletes for multiple visuals/dimensions or multiple themes could be used in one file? MS Excel allows for this actually pretty well.
2. Does Power BI remember the color associated with a dimension series/value or rather allow the report developer/designer to import/reuse colors used by another visualization (sliced by the same dimension) within the same report/dashboard?
I believe it is really important to use the same color for a dimesion value in all charts and for that color to be not used by and other dimension value so that the end-user/client is not confused. For example as Brandname Contoso uses the color blue (00B8F1), then the Class 'Deluxe' and subcategory 'Computer accesories' should not use the same color (00B8F1). Class 'Deluxe' and subcategory 'Computer accesories' should use different colors. And also the report designer should have the option of using same color pallete for another visualization slice by brandname as used by the treemap.
Thanks.
Hi @cyclist007, thank you for your feedback! Yes once a color has been associated with a category on a page, we keep those synced across visuals. For example, if you create one visual with "computers" colored blue, other charts with "computers" in the legend would also be blue.
The way we would likely handle #1 would be to assign colors based on category. That would let you make sure computer accesories and contoso never have the same color. You can do this now manually in the formatting pane, but not yet programmatically through the theme. We could definitely add this to the theme in the future if there is enough ask for it. You should suggest it as an idea on our ideas forum, ideas.powerbi.com.
Thanks Amanda for the quick response. I believe #2 works only when using the theme colors, if you manually assign a color to category/dimension value, and then plot a new chart with the same category/dimension it does not pick-up the same/assigned color. Please let us know if there is some setting to ensure the category value always shows up with the manually assigned color.
#1 is really important for making effective use of colors. Doing it manually is cumbersome especially if you are slicing the multiple dimensions on multiple charts (you would have to manually match the colors for each dimension value). I have put this as an idea but would appreciate if this taken up by your team sooner - allowing for multiple themes to be applied in a report/dashboard might be a quick fix as well as make the dashboards look richer.