Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
marcelofnr
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
negi007
Community Champion
Community Champion

@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 on linkedin

View solution in original post

4 REPLIES 4
v-kelly-msft
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!

negi007
Community Champion
Community Champion

@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 on linkedin

Ashish_Mathur
Super User
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.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
mpicca13
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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.