Skip to main content
Microsoft Idea

Power BI

Needs Votes

Having multiple color palettes/themes for different dimensions/visualizations and different hierarchies (drill-downs)

Vote (3) Share
Mustafa Biviji's profile image

Mustafa Biviji on 21 Mar 2017 01:53:27

Power Bi just implemented custom themes but what this does is applies the same theme to all the visualizations. This is could be very confusing to the end user. Suppose you have multiple metrics (like sales, profits, margins, etc.) that are sliced by geographical region as one dimension and say Item category as another dimension. Currently the same top 5 colors of the theme would be used for the top 5 geographical regions and top 5 item categories.

Each dimension should be using a distinct color palette. That is say California and Clothes should not be using the exact same color. The both could be blue in color but they should be distinguishable shades of blue.

Currently this has to be done manually. Even MS Excel has multiple color palettes for use on different charts.

A similar issue is also seen in hierarchy colors. That is the state of California and city of Houston (drilled-down from Texas) could have the same color.

For different dimension values there should always be a different color. And there should be color palettes/themes pre-built (as doing this manually is time-consuming and not intuitive).