Forum Discussion

ReneeKoelewyn's avatar
ReneeKoelewyn
Frequent Visitor
1 year ago
Solved

Structuring dataset for better visualization

Good day,   I am struggling to structure my dataset so that the x-axis represents the campuses and the qualifications are grouped per year per campus. I have included an example of what the cluster...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    1 year ago

    Thanks for the concern from Ritaf1983.

     

    Hi ReneeKoelewyn ,

     

    Based on your description, I created simple data:

     

    I performed the following:

     

    1.Select the first column and unpivot the other rows in Power Query Editor.

     

    2.Change data type:

     

    3.Create two new columns:

     

    Year = 20&LEFT([Attribute],2)
    Campus = RIGHT([Attribute], LEN([Attribute]) - 2)

     

     

    Result:

     

    If you still have any questions, can you provide a more detailed description or a .pbix file with the private data removed.

     

    Best Regards,
    Zhu

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.