Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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?
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.