Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
Hi @Matthias93,
According to your description, you want to display different answers on X-axis, and show average value for each answer, right?
In your scenario, you can open Query Editor and select columns from Answer 1 to Answer 8, then click Unpivot Columns under Transform tab. See:
Best Regards,
Qiuyun Yu
Hi @Matthias93,
According to your description, you want to display different answers on X-axis, and show average value for each answer, right?
In your scenario, you can open Query Editor and select columns from Answer 1 to Answer 8, then click Unpivot Columns under Transform tab. See:
Best Regards,
Qiuyun Yu
This worked perfectly for me, thank you very much
You can add Text columns as x-axis values. Or, you might add an Index to your import?
User | Count |
---|---|
101 | |
90 | |
80 | |
71 | |
70 |
User | Count |
---|---|
114 | |
98 | |
97 | |
73 | |
72 |