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.
Hi.
I have a question about transpose function in Power BI.
The table above, looking at the data structure can be transposed by the DATE column, to be like this
I've been trying using the transpose function in the query editor, but the result is not how i think it suppose to be.
Can you help showing me how to use the transpose in the query editor to get the result like in the second picture?
Thanks.
Solved! Go to Solution.
Hey,
basically it's a good thing for the data model to have the measures in columns.
To achieve what you want, just use the Matrix visual from Power BI Desktop, drag the Month columns to the columns, the measure to values
And finally use the Option from the Formatting Pane of the Matrix visual to show the values on Rows
Mark the Visual
Format -> Values -> Switch "Show on rows" to on
Hopefully this is what you are looking for
Regards
Tom
Hey,
basically it's a good thing for the data model to have the measures in columns.
To achieve what you want, just use the Matrix visual from Power BI Desktop, drag the Month columns to the columns, the measure to values
And finally use the Option from the Formatting Pane of the Matrix visual to show the values on Rows
Mark the Visual
Format -> Values -> Switch "Show on rows" to on
Hopefully this is what you are looking for
Regards
Tom
Well thanks for the help
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 |
---|---|
110 | |
94 | |
80 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |