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 everyone I know beforehand that there are many posts on this matter "transpose a table", but the table that I am trying to transpose is already in the canvas, and I just want to transpose after doing the calculation (count)
The original table is very simple two columns and 20 records
Best Regards
Solved! Go to Solution.
Could you just use a matrix visual and put your field in columns, with nothing in the rows?
If this works for you, please mark it as solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Hi, @Anonymous
Based on your description, I created data to reproduce your scenario.
Sheet1:
You may try to use a matrix visual with Columns as 'Case A' and Values as 'ID' to display the result.
If you want to do a Transpose in Power Query, you may click 'Transform data', go to 'Query Editor', click 'Transform' ribbon=>'Pivot Column', set as below.
Then you may use a table visual to display the result.
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Anonymous
Based on your description, I created data to reproduce your scenario.
Sheet1:
You may try to use a matrix visual with Columns as 'Case A' and Values as 'ID' to display the result.
If you want to do a Transpose in Power Query, you may click 'Transform data', go to 'Query Editor', click 'Transform' ribbon=>'Pivot Column', set as below.
Then you may use a table visual to display the result.
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If you really must do a transpose: https://community.powerbi.com/t5/Quick-Measures-Gallery/TRANSPOSE/m-p/630229#M314
Could you just use a matrix visual and put your field in columns, with nothing in the rows?
If this works for you, please mark it as solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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 |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |