Table Header Font Color changing when promoting from lower environment

Question & Answer
, ,
1

In lower environment, we have the table header font color white with a blue background. When we promote through the folders to prod, it is changing the font color to black. This is happening every time we promote changes/fixes despite the color remaining white in the lower environment.

Our dashboards are embedded to provide access to our external customers and we’ve had to field several complaints about this so far. Any thoughts on why this is happening or how we can resolve appreciated.

Before (in QA):
image

After (in PROD):
image

2

Hello @krushmere

In the past I have experienced temporary issues with table visual formatting similar to this but it usually goes away during a refresh.

What is your process for moving the analyses/dashboards through accounts prior to publishing to your embedded environment? I wonder if there could be a dashboard_id from an earlier version that has not had the formatting updates being passed along instead of the correct version dashboard_id.

You could also try pulling the definition of the published analysis/dashboard to see what color it is showing in the meta data:

https://awscli.amazonaws.com/v2/documentation/api/latest/reference/quicksight/describe-analysis-definition.html

Under TableOptions -> (structure) & HeaderStyle -> (structure)

BackgroundColor -> (string)

> The background color for the table cells.
3

Hey Duncan,
Thanks for the quick reply!
This analysis has two tables, one where the font color is always set to default (the problem behavior) and one where the font color stays to what we set it to.
Here is a screenshot of the table options for the ‘bad’ one

image
image430×499 7.46 KB

And here is a screenshot of the table options for the ‘good’ one

image
image475×557 7.91 KB

As you can see, the first one does not have a font color property, but the second one does. Is there a way to “force” the font color tag, or even to just check and make sure it gets added without having to go through the process of promotion?

4

If you have the same colour fonts in all the tables, i think you can fix this using themes. That would help you set the default.

5

We do have a theme set for this particular dashboard

6

Hey @drew.virgin & @drew.virgin

I would try hard coding it into the analysis definition and updating this across accounts programmatically. If you still run into the error after that you may need to create a support ticket.

7

Hi Duncan,
Thank you again. I’m trying to hard code the header font color but I’m not making as much headway as I would like.
Could you look at it and maybe help guide me with what I’m doing wrong here?
Here is a look at the command in CloudShell
image

Here is the value I’m trying to send via definition on the update-anaylsis that is a bit more readable

image
image534×480 5.47 KB

When I run that, I receive an error of ‘Unknown options’

8

Hey @drew.virgin & @krushmere

That first image is hard to read (webpage wont expand it for some reason) but I’m not sure why you would run into an ‘Unknown options’ error if its from the documentation.

Can you share the command you ran and was there anything else in the error message like the offending line/function?

9

Hey Duncan,
Not sure what happened with that first image. Here are the lines of code that I have used to attempt to set the FontColor on the header. Here is the code using the --query option to get to the right element:

aws quicksight update-analysis --aws-account-id ** --analysis-id ** --name "**" --query Definition.Sheets[0].Visuals[24].TableVisual.ChartConfiguration.TableOptions.HeaderStyle.FontConfiguration --definition {"FontColor","FFFFFF"}

when this command is run you get the message ‘Unknown Options: FFFFFF’

and then when attempting to update without using the query option to specify where to look

aws quicksight update-analysis --aws-account-id ** --analysis-id ** --name "**" --definition {"Sheets":[{"SheetId":"**","Visuals":[{"TableVisual":{"VisualId":"**","ChartConfiguration":{"TableOptions":{"HeaderStyle":{"FontConfiguration":{"FontColor":"FFFFFF"}}}}}}]}]}

the unknown options error shows up here, but basically repeats everything after --definition

All that said, I believe we have found/isolated the problem. It looks like you can change the fontColor tag through the UI, but if you change the font type or font size, it throws the fontColor away. This is reproduceable for us. We are using the Free-form sheet setting if that makes a difference.

1 Like