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!

     

PowerBI_Scott's avatar
PowerBI_Scott
Frequent Visitor
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!