Forum Discussion
Pivot Columns Excel/ Power Query
Hi ale259,
Thank you for reaching out to Microsoft Fabric Community Forum.
Load the data into Power BI and open Power Query Editor by selecting Transform Data.
You can proceed step by step in Power Query to achieve your expected output.Ensure the date column is converted to a time-only format. To do this, select the column and choose Time from the Data Type dropdown. This will display only the hourly values.
Select only the "Hourly" column, then go to Transform → Unpivot Other Columns. This will convert "A City" and "B City" into two columns: "Attribute" and "Value".
Rename "Attribute" to "City" and "Value" to "Visits".
Sort it from the filters dropdown in ascending or descending order.
Here is the output.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Regards,
Vinay Pabbu
Hi, do I need this part if I have this data range already? I don't qute understand what this long code mean. If you could explain it, it would be great. Thank you!
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjSyMjBQcPRV0lEyNDAwAFJGQDJWBygDlzCFSJhAJRA6zCESZgZQGWO4jAVExhwmY4JiiwFEhVJsLAA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Hourly = _t, #"A City" = _t, #"B City" = _t]),
Read note below my posts.