Forum Discussion
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...
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.
Go into the query editor by clicking transform data. Then select all the columns that pertain to a product by holding down the shift button, while selecting the first column and then select the last column. This will highlight all the columns you want to transform. Then click on the button at the top ribbon called unpivot. This will then take all the product columns and transform them to rows. From here you should be able to then further tranform and analyze your data in a more effective way.