Sync the color of legend of Line Chart and Bar Chart

Question & Answer
, ,
1

image
image1360×727 63.8 KB

Is there way to make the color of legend in sync between Line Chart and bar Chart? Without hard-coding, please.

Thanks!

2

Hi @lbl
is the Year a date or string/number field?
BR

3

hi @ErikG
Year is number field

4

Would it be an option to use the “field colors”?

grafik
grafik171×177 6.47 KB

5

Hello @lbl, I hope this message finds you well.

There is an alternative that I love to use, which is as follows: If you click on the legend, it will open a window with these options:

image
image261×159 7.26 KB

Click on “EDIT FIELD COLOR.” After that, you can edit the color of that point on the legend across the entire dashboard.

Please let me know if it works.

6

“Edit field Colors” is static by indicating color to known values. In my case, values of year are dynamic. Hence, I am unable to use “Edit field Colors”.

7

hi,
Would like to check if any solution or workaround, please. Thank you.

8

Would also be a useful thing to know - we similarly can’t hard lock the colours using “Edit field color” as that won’t work across all our different dashboard users (some will have different ranges), plus it requires maintenance each year. But having different colours for the same year across charts is confusing to users!

9

@ErikG
would you be able to raise this to QuickSight team for a solution or workaround?
apology if it is inappropriate to request this way.

thanks.

10

Hi @lbl,
From my understanding, I do not believe there is a standard way to set the color on a field that’s values are dynamic.

Just out of curiosity, how is that field static (what’s the calc. field formula you’ve created for it)?

I don’t believe there are any great work around options for dynamic value coloring but one thing you could try:
Edit the data colors in your theme settings:

image
image203×199 7.3 KB

While this won’t match colors to specific values per say, it will use those colors in order so if you are using the same calculated field on separate visuals (so it returns the same year options across numerous visuals) they should all coordinate. Visuals will follow that color order set in ‘Data Colors’ so the first value returned will be the light blue in my example, your second value will be dark blue, and so on.

I’ll mark this as a feature request as well to promote visibility to the support team but let me know if that work around serves as a solution for your case.

11

hi @Brett

YEAR is a number field directly from dataset (not calculated field).
Editing data colors in theme settings does NOT solve the issue.

image
image310×114 4.09 KB

Bar chart without small multiples IS following the theme.
image

BUT line chart with small multiples IS NOT following the theme. Tested with Bar Chart which also has the same issue.
image
Another issue noted is that the YEAR cannot be sorted in desc or asc. I will log separate case for this.

It seems to me that small multiples implementation has bug. Would appreciate support team can look into this for a solution.

Thanks.

12

Hi @lbl,
I mentioned this on your other post as well; there does seem to be a bug with this so I would suggest creating a support ticket.

1 Like
13

Hi @lbl,
Please refer to my response on your other like posts. I’ve marked this as a feature request and provided this information to our contact at AWS. Hopefully this bug will be able to be straightened out. For the time being though, I’ll go ahead and close out this topic.

Thank you!