Forum Discussion

PowerBI_Scott's avatar
PowerBI_Scott
Frequent Visitor
3 years ago
Solved

Colors for a value that does not exist yet

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 custome...
Need Help
  • PowerBI_Scott's avatar
    PowerBI_Scott
    3 years ago

    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's avatar
ppm1
Solution Sage
3 years ago

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