Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am trying to replicate a excel visualisation in power bi.
The visual is using data from a excel table which looks like the picture below:
How can I transform the table so that the stats rows on the left are individual headers for each column at the top? For example I need to select January (Avg) as a field when creating visuals in power bi.
At the moment the power bi does not recognise these as headers.
Many thanks for your help!
Solved! Go to Solution.
Use "unpivot" in Power Query:
Please give it a thumbs up if this helps!
Use "unpivot" in Power Query:
Please give it a thumbs up if this helps!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |