Forum Discussion
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, it cannot interact with the rest of the charts in the Power BI tab. Does anyone know how I could fix this without changing the database format? Any formula to help me separate the data? Thanks :),
If someone speaks Spanish and could help me it would be incredible
| Tittle of the news | Reach | Ad.Value | Product A | Product B | Product C |
| Tittle A | 1000 | 50 | x | x | |
| Tittle B | 500 | 20 | x | x |
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.
4 Replies
- negi007
Community Champion
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.
mpicca13Resolver IV
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.
- Ashish_Mathur
Super User
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.
v-kelly-msftCommunity Support
Hi marcelofnr ,
Is your issue solved now?
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
