I have a straight table chart (I think it needs to be a straight table) in order to have the value column much thinner than the expression name - but happy to be proven wrong if pivot table would also work. I would ideally like to group up the expressions so that the category for each KPI is shown.
At the moment, I have this as 2 separate charts where the value of ED is one and then KPI text and Target is another chart. Ideally, I'd like to be able to just have the one chart with all 3.
Is this possible at all? If so, what is the best way to achieve this?