Forum Discussion

redzum's avatar
redzum
Frequent Visitor
9 years ago
Solved

Reshape data to simplify visual plot

Hi All,   I'm new here and beginner in PBI. I have data originally with 5 columns and to be manipulated for visuals (line & bar chart). I have to introduce new column to re-shape & calculate the di...
Need Help
Tips and Tricks
  • MattAllington's avatar
    MattAllington
    9 years ago

    Unpivoting as a principle should not be impacted by how many columns you have. I don't think you need to use VBA in preference to Power Querr

redzum's avatar
redzum
Frequent Visitor
9 years ago

Hi Matt,

 

Thanks for help, really appreciate it. Actually original file are with many columns with other parameters more than what i provided before, see as attached. That is the reason why i need to find a way to re-shape the data at the 1st place. Perhaps i need to reshape the data using VBA in excel prior import to PBI if DAX is not possible to do it?

 

  

 

Redzuan

MattAllington's avatar
MattAllington
Community Champion
9 years ago

Unpivoting as a principle should not be impacted by how many columns you have. I don't think you need to use VBA in preference to Power Querr

  • redzum's avatar
    redzum
    Frequent Visitor
    9 years ago

    Hi Matt,

     

    I managed to automate by using unpivot in data query. This is what i need. Thanks for the solution. Awesome!

     

     

    Thanks

    Redzuan