Forum Discussion

powertron's avatar
powertron
New Member
3 years ago

Showing Consistent Colors on a Graph Legend

Hi,   I have a bar graph which is showing values from a table, this graph has a date range which can be lowered/increased to show information over different timeframes.  Standard stuff so far. Whe...
Need Help
LaurenceSD's avatar
LaurenceSD
Advocate II
3 years ago

Hi,

 

I experienced this as well & found the fix was to select Show items with no data

 

 

This way when one field drops off due to having no data the colours will remain the same as it'll still be there in the legend bar

  • powertron's avatar
    powertron
    New Member
    3 years ago

    Hi,

     

    I've tried this (assume I should be selecting this on the "Legend" value?) : 

    However the issue is the same.  If I select a date range where only 2 of the values are selected it shows one color scheme : 

    And this is not consistent when there are more values: 

    • LaurenceSD's avatar
      LaurenceSD
      Advocate II
      3 years ago

      Is your legend data coming from a Fact or Dimension table? I'm guessing it's the former, if you put the legend data into a Dimension data and then create a 1 to many relationship, then the method mentioned above should work