How to create a stacked column table from many different columns

Hi NQT1711 ,

Using some data prep in Power Query (or in the backend if you have access) you could achieve this by UNPIVOTING the columns you need on the x-axis. Here is a reference on how to achieve this. https://learn.microsoft.com/en-us/power-query/unpivot-column

Once you've done that youll be left with a column for the x-axis with all the labels such as "GENERAL, PERFORMANCE etc." and another column with the attributes (positive, negative, neutral). You can then use a count function on a stacked bar chart with the labels on the x-axis, the count function as the values and the attribute as the legend.

(Side note, from what I can see of the data when you unpivot this will cause your ID column to no longer be unique. If you are using it in any relationships on the 1 side then you may need to refactor your modelling.)

Hope it helps,

Kris