Skip to main content
Microsoft Idea

Power BI

New

Customize the color of columns in chart with data table

Vote (1) Share
Ming Ye's profile image

Ming Ye on 07 Jul 2022 07:18:12

We have several charts (Stacked Bar Chart, Pie Chart, Donut Chart, etc.) in one Power BI report, each one is related to trucks with different series, such as:

Vehicle ID 1101, FM Series; Vehicle ID 1102, FM Series; Vehicle ID 1103, FMX Series; Vehicle ID 1104, FH Series, etc.


End users would like to have unique color for each series. For example, all slices/columns/bars related to FM series displayed in Navy color,

Currently we have to add color configuration for each series in each chart one by one, it is quite time consuming.

And we can only do that when the series exists in database. That means, it we are about the release another series FEX next month, it is not feasible to add related color configuration in advance.


I wonder if it is feasible to add the color configuration via data table, such as:

Series Color

----------------------------------

FH #7285A5

FM #4F97A3

FMX #57A0D3

FL #4682B4

FE #81D8D0

OTHER #3FE0D0

N/A #0080FF


In Visualization Format pane, developers just need to specify the "Value" column and "Color" column for the chart. It can be quite useful to keep chart styles consistent in single report.