% labels on a stacked column chart

[Kelley_Nelson]

Hi folks! Looking for some help here. I am fairly advanced with Quicksight but I’ve come up with a request that is stumping me. We have a request to be able to show % of total labels on a vertical stacked bar chart. I believe this is possible with other BI tools. (In fact, Quicksight’s own chatbot offered me solutions for other tools but not Quicksight itself )

Requirements:

1. We don’t want a 100% chart. The heights of the bars should vary based on the totals.
2. We don’t want a combo bar + line chart. Some people find this confusing.
3. I tried an interesting workaround based on this post: Data label formatting doesn't match what's set for value . But it’s not a great solution because I can’t select which labels I want to show, I can’t show the percentages labels in the right format, and the legend is confusing.
4. We don’t want two charts.
5. We can’t use tooltips because the dashboard tab needs to be exported as a pdf and printed.

Does anyone have an alternate solution? There are several posts from 2022-2023 but none with a solution. I feel that Highcharts may offer a solution, but I don’t have experience with Highcharts and I can’t find a similar example to help me get started. It’s a pretty steep learning curve for just one visual.

Here’s my analysis with dummy data in Quicksight Arena: Stacked Column with % Labels Options

Appreciate any help you can provide.

[David_Wong]

Hi @Kelley_Nelson,

The way to do that in QuickSight is by creating a calculated field to calculate the percentage and then adding that calculated field as a tooltip but first you need to put your dataset in this format:

Are you able to have a Type column that contains A or B instead of separate columns for Type A and Type B?

Then create a calculated field to calculate the percentage and add it to the tooltip. It will look like this:

[Kelley_Nelson]

Thanks, David. Unfortunately a tooltip will not work for us, because the sheet needs to be exported as a pdf and printed.