Forum Discussion

nholmes12's avatar
nholmes12
Frequent Visitor
4 years ago
Solved

Unpivot Data/ merge table

Hi All,    Still quite new to Power BI myself so looking for assistance with the below. I have the below data set in the following (excel) format which shows change in headcount and cost over time:...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi again nholmes12 ,

    I was maybe not enough clear in my previous post.
    To pivot your data : simply select your column "Value Type" and click on Pivot column. In the windows which pop-up select Value as Values column and in Advanced Options select "Don't Aggregate". It should work.


    Please accept it as a solution if it solved your issue.
    Best regards

nholmes12's avatar
nholmes12
Frequent Visitor
4 years ago

Thanks for the response. I did try this option and it worked well. My only thought was that it may limit my ability to create charts that can compare cost to FTE change over time as I only have one value field?

 

When you say pivot the ValueType and value, that doesn't appear to be working for me. I have pivoted both columns by attribute which gives the following:

Then pivoted the Value by the type which gives:

 

Any idea what I am doing incorrectly here?

 

Thanks!

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi again nholmes12 ,

I was maybe not enough clear in my previous post.
To pivot your data : simply select your column "Value Type" and click on Pivot column. In the windows which pop-up select Value as Values column and in Advanced Options select "Don't Aggregate". It should work.


Please accept it as a solution if it solved your issue.
Best regards

  • nholmes12's avatar
    nholmes12
    Frequent Visitor
    4 years ago

    Thanks very much!