cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

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 newsReach  Ad.Value Product AProduct BProduct C
Tittle A100050x x
Tittle B50020 xx
1 ACCEPTED SOLUTION
Super User II
Super User II

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

 

negi007_0-1601715690227.png

 

After unpivoting your data would look like below

 

negi007_1-1601715735258.png

 

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

 

 




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


Proud to be a Super User!

Follow me here


View solution in original post

4 REPLIES 4
Community Support
Community Support

Hi  @marcelofnr ,

 

Is your issue solved now?

 

Best Regards,
Kelly

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

Super User II
Super User II

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

 

negi007_0-1601715690227.png

 

After unpivoting your data would look like below

 

negi007_1-1601715735258.png

 

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

 

 




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


Proud to be a Super User!

Follow me here


View solution in original post

Super User III
Super User III

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.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Resolver IV
Resolver 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.

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Microsoft Ignite

Microsoft Ignite with Arun Ulag

Featured Session Drive Data Culture with Power BI: Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI ​

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors