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.