I want to display some stacked values in a bar chart, along with their overall percentage variation relative to the previous time period.
Option 1: include something like the bars below into a straight table. I wouldn't know how to do it using simple linear gauges. Any tips?
Option 2: alternatively, I can just have two bar charts: one with the values above and one with the time variation; however, the dimesions of the charts should be linked. I tried by inputting the expression of one chart as sorting expression of the other, but zero or negative values are not sorted correctly and always appear at the bottom. Moreover, filtering zero values would not work correctly: a value with no percentage variation wouldn't show up, while I'd want to filter out the zero values of the sorting expression.
Any idea how I can visualise all the info above in a consistent way?