In this example, all the values in the first row have full-width data bars because they are the largest values, and then all other data bars in their columns are shown in proportion to the first value. In reality, all these values are parts of a whole (see the Total values at the bottom), and so I would prefer to show their relative percentage of the whole. For example, the first blue bar should only fill 62% of the box because 1254 is 62% of 2018.
I am used to formatting data bars this way in Excel, where you can set the maximum scale.
Hello @gschiff , welcome to the QuickSight community!
I did some testing and wasn’t able to find a way to change how the scale worked in the data bars so I’m guessing it was designed that way. I will mark this post as a feature request for the QuickSight team to allow a user to select a dynamic max value.
Also, I tried a work around using percent of total to see if that would change anything and I got the same result:
In Amazon QuickSight tables, As far as i can think of there is no functionality to control the scaling of data bars to show percentages of a total or to set a custom maximum scale.
Data bars in QuickSight are measured relative to the range of all cells in a single column, similar to a bar chart. This means the largest value in each column will always display a full-width bar, with other values shown proportionally to that maximum value. for reference see
Thank you @duncan for tagging it as feature request.
Thank you Deep and Duncan. You confirmed what I could plainly see… that it automatically scales the largest value in a column as the full-width bar. My feedback is that this is not a great assumption for many use cases, including the “parts of a whole” example I gave. Please consider adding the feature to define the scaling based on a constant or a variable.