Forum Discussion

Mo_15797's avatar
Mo_15797
Frequent Visitor
2 years ago
Solved

Convert Data in Power BI

Hi,   I currently have a dataset in excel (yellow table in the image below). I would like to know if there's a way to convert it to create a column for each hierarchy, for example, see the green ta...
Need Help
Tips and Tricks
  • Mo_15797's avatar
    Mo_15797
    2 years ago

    Hi KEAlexander - Thanks for your response. I managed to get it to work after watching a few youtube videos. I used the Pivot function on the "hierarchy" column to create the new columns, and then selected the "title" column on the Value Column. I configured the settings on the "Advanced options" on this pivot function to "Do not aggregate" so it shows me the values in non-numerical format. 
    I then used the "Fill up" and "Fill down" function to populate the fields in the table where it was necessary. 

Mo_15797's avatar
Mo_15797
Frequent Visitor
2 years ago

Hi KEAlexander - Thanks for your response. I managed to get it to work after watching a few youtube videos. I used the Pivot function on the "hierarchy" column to create the new columns, and then selected the "title" column on the Value Column. I configured the settings on the "Advanced options" on this pivot function to "Do not aggregate" so it shows me the values in non-numerical format. 
I then used the "Fill up" and "Fill down" function to populate the fields in the table where it was necessary.