It is possible to show multiple values in bar charts by displaying the total value at the top of each bar and the percentage of the total within the bar itself. This can enhance data insights by providing both absolute and relative values in a single visualisation, making it easier for users to understand proportions and contributions within a dataset.
Steps to Implement:
Add Totals β Position the total values at the top of each bar to display the absolute numbers clearly.
Show Percentages Inside Bars β Place percentage labels within each bar, representing each value as a percentage of the overall total.
This approach makes bar charts more informative by combining absolute and relative data points, improving data accessibility and interpretation for users.
Select your data and choose the stacked bar visualisation then jump from 'template' to 'custom'
Once you've split the stacked bar using the colour field, you can add the value into the label field.
Click on the 3 dots and normalize the data to show the % of each segment.
Duplicate the bar mark and swap it to a "text" type.
Remove the metric you used to split the bars by colour.
Remove normalization and this will give you the total value.