Forum Discussion

DAW's avatar
DAW
Regular Visitor
8 years ago
Solved

Changing Data before it is used by PowerBI

I am using the Analytics connector for VSTS, and attempting to create a chart that shows me a trend by the first section of the area path.  Is there a way for me to mess with the data before it gets ...
Need Help
  • Seward12533's avatar
    Seward12533
    8 years ago
    Use power query (Edit Query) to transform your data before it gets loaded.
  • v-yuta-msft's avatar
    v-yuta-msft
    8 years ago

    Hi DAW,

     

    You can click Query Editor-> Transform-> Split Columns as below:

     

    Then you can group by "something":

     

     

    Regards,

    Jimmy Tao

v-yuta-msft's avatar
v-yuta-msft
Community Support
8 years ago

Hi DAW,

 

You can click Query Editor-> Transform-> Split Columns as below:

 

Then you can group by "something":

 

 

Regards,

Jimmy Tao