Forum Discussion

marcelofnr's avatar
marcelofnr
New Member
5 years ago
Solved

Help w/ Power BI

Hello good afternoon. I need some help. I have a database that distributes the products in columns and not in rows. When I want to make a chart that gathers the information from different columns, i...
Need Help
Show and Tell
Tutorial Requests
  • negi007's avatar
    negi007
    5 years ago

    marcelofnr  You can open your data in the power query window and then unpivot product column like below

     

     

    After unpivoting your data would look like below

     

     

    If you wish to have anything else, please let us know.

     

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
5 years ago

Hi,

You will have to change the structure of your dataset in the Query Editor.  Select the first 3 columns > right click > Unpivot other columns.

Hope this helps.