Two variables average over a bar graph.

Hi josegovia,

Suppose your source table looks like:

You can use a clustered column chart to show the average values for satisfaction and knowledge. But the limitation is that it is not possible to show the label as the name of the variable or a custom value, data labels can only show the numeric values for each bar.

As a workaround, you can unpivot the table structure first in query editor mode. Select the [Case type] column, then from Transform menu tab, choose 'Unpivot other columns' from the drop down list 'Pivot Column'. Then, you will get a table as below.

Best regards,
Yuliana Gu

Hi josegovia,

To keep the original table structure, you can replicate a new table, then, you can unpivot columns based on this new table.

Best regards,
Yuliana Gu