Colors for a value that does not exist yet

[PowerBI_Scott]

Is there a way to assign a color to a bar or line in a "Line and stacked column chart" or "Line and clustered column chart" where the data point does not exist yet.

For example, we have 4 customers:

Walmart

Target

Kroger

Safeway

We are adding Publix.  As soon as Publix goes on-line it should show up in the charts.  The colors for each customer is predefined, so I'm trying to avoid a situation where Publix shows up one day and it is assigned a random color. (Additional request: It would be nice to assign global colors to certain values, unfortunately the conditional formatting doesn't appear as an option.  If there is a way to easily assign global colors let me know, please.)

Is there an easy way to select a color for a value in a legend/bar/line when data does not exist in the dataset?

[PowerBI_Scott · Accepted solution]

Thanks for the suggestion.  I have the tables using values from a dimension table, but with no data, it was still not coming up as an option.

Your suggestion gave me another idea.  Rather than manually creating a tables for everything (which would have been very painful), I modified the data that was loaded to return the value I wanted in place of one of the others (e.g., CASE WHEN customer = 'Kroger' THEN 'Publix' etc.).

It would still be best if there was a place I could assign a global color for certain values, but for now this works.

Thanks again!

[ppm1]

Not necessarily "easy" but you could add a table of all future expected values with the desired hexcode color (or just add hexcode to an existing dimension table that has all expected future values. You could then create a measure that grabs that value based and use it as the conditional formatting value for each bar.

Pat