Forum Discussion
Transformation / calculated table
Dear Community, I look for solution for the following problem. 1. I have a table with raw data - e.g. shipments form A-to-B with various service providers and their offered prices. Shi...
Hi Anonymous ,
You will need to unpivot your table.
Select First 2 column and then click on Unpivot Other Column
You cna then just pull the columns in the visualization pane to get your results.
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
Anonymous , you have an option in edit query /data transformation mode.
Refer document
https://radacad.com/pivot-and-unpivot-with-power-bi
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/