Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!See when key Fabric features will launch and what’s already live, all in one place and always up to date. Explore the new Fabric roadmap
Data
GraphHi,
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 |
---|---|
88 | |
74 | |
69 | |
59 | |
56 |
User | Count |
---|---|
40 | |
38 | |
34 | |
32 | |
28 |