I am transitioning some dashboards from Tableau to Quicksight and I am looking for a functionality found in Tableau in creating tables with as many columns as possible and then having a horizontal bar chart next to it. I know about Data Bars, however, I want the ability to customize the bar chart. My current data has a group and a subgroup and a measure for the % registered in the subgroup. My ideal visual would show the first column as the Group, then Subgroup then horizontal bar chart with % registered but the bar chart should be up to 100% and fill up the percent of registrations to make it easier to compare between the different subgroups. Then, I want to implement conditional formatting to the bar to show different colors for different ranges of % registered.
I have created a sample visual, but please note that my mock data ranges from 0-100% hence, the bars’ range is for 100%. My data’s % ranges from 0-20% hence it considers 20% to be the max. I would also prefer the first column that shows the group name to only appear once, similar to how the pivot tables are and not in each row as in the screenshot. Finally, I wish to have a nested sort, first by Group and then by Percent Registered.
