New to QuickSight create a Grid (Table) with color formatting based on Status

Question & Answer
1

I am using field values: ‘Project Type’, ‘Project Name’, ‘Release date by Week’ and ‘Project Status’

I created a table with Column as ‘Project Type’ and Row as ‘Release date by week’.

I am trying to :

  1. Have ‘Project Name’ to be displayed by ‘Release date’ and show color of the ‘Project status’.
    Or at least:
  2. Have ‘Project Name’ cell by color of the ‘Project status’ color.
    Example: Highlight ‘Project Name’ as ‘Test 1’ with ‘Green’ as the ‘Project Status’ is ‘Green’ for this project.

Thank you!

2

@dthequicksight9 - Thank you for posting your query. You can leverage the conditional formatting feature of QuickSight in this case. You need to set up multiple conditions based on the finite list of values that you have in Project Status. I have tried to replicate at my end using a different dataset, but the concept will be same.

You need to set up multiple conditions for each of your Project Status.

A Sample Snapshot for your reference is given below:

image
image1081×734 61.4 KB

Did my suggestion help you in resolving your query? If yes, would request you to mark the post as “Solution”. This will help the community to find guidance and answers to similar question. Thank you!

1 Like
3

Thank you for the response. If I don’t want the entire row highlighted, but only one cell which has the Project Name highlighted. How do I achieve this? Thank you!

4

Hi @dthequicksight9 , Instead of selecting the Entire Row options from the Select Column drop down please select the Project Name column from the Select Column dropdown.

For achieving this just need to go to the three dotted menu options click on conditional formatting then go to Delete button and recreate the same conditional formatting by selecting the Project Name column from the available dropdown options.

PFB some of the screenshots
Step -1
image

Step -2
image

Step -3
image

No need to select the Entire Column button instead you select the Project Name column for getting the exact result.

Please delete the conditional formatting and create the conditional formatting as provided by @sagmukhe with conditions.
I have added all the above steps for getting the exact result from your end.

Thanks & Regards
Biswajit Dash

1 Like
5

Hi @Biswajit_1993
I wish to highlight an entire row although through conditional formatting I am unable to see [Entire Row] as an option, could you help me understand why this might be happening ? (Attaching a screenshot for reference)

image
image1536×473 88.1 KB