No values on x-axis

[Matthias93]

Hi,

I'm trying to make a clustered colum chart, but I have no values on my x-axis. This makes that the bars of my chart are really close to each other and make for an ugly visual. My data is built up as follows: Answer 1 (Value) Answer 2 (Value)... The value ranges between 1 and 5 in whole numbers. On the x-axis I would like to have the different answers or questions and on the y-axis the average values per answer. Can somebody help me do this?

Thanks in advance,

Kind regards,

Matt

[v-caliao-msft]

Hi @Matthias93,

What's your data source looks like? Can you provide us some screenshots about your table?

I have tested it on my local environment. My sample table looks like

Drag QuestionNumber to Axis and drag Answer to Values, then change aggregate fucntion to average.

Regards,

Charlie Liao

[Matthias93]

Hi @v-caliao-msft here you can see a sreenshot of my data source. The problem is that the value and the question number are in the same column. Thank for helping!

Kind regards,

Matt