I have a query regarding a limitation i encountered in Amazon QuickSight when working with the vertical 100% stacked bar chart. It appears that QuickSight does not allow the use of two variables (dimensions) on the X-axis for this chart type. This restricts the level of detail and comparative analysis one can achieve in a single view.
In comparison, Power BI supports multiple variables on the X-axis for the same visual. I was wondering if there is a workaround for this, or if this is a known limitation with no current solution.
Hello @Olaitan hope this message finds you well!!!
in qs, you cannot use multiple dimensions on the X-axis for 100% stacked vertical bar charts, which is a known limitation 
. As a workaround, you can concatenate the desired dimensions into a calculated field, such as concat({Category}, ' - ', {Subcategory}), and use it on the X-axis. Alternatively, you can use hierarchies to explore different levels of detail interactively, although this does not display both dimensions simultaneously. If these solutions are insufficient, consider using Highcharts for more advanced charting capabilities or integrating QuickSight dashboards into applications for greater flexibility. Additionally, you can explore using AWS Rules to automate data processing and visualization tasks.
Thank you. I will take some time to explore these options further