Help w/ Power BI

[marcelofnr]

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

[v-kelly-msft]

Hi  @marcelofnr ,

Is your issue solved now?

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[negi007 · Accepted solution]

@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]

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.

[mpicca13]

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.