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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
GabrielActemium
New Member

How to display data from several columns in a graph?

Hello, 

 

My name is Gabriel, i'm a beginer in PBI and i need help. 🙂

I would like to show in one graph  data from several columns, but i don't know how to di it. 

In my datas, there are columns about topics like "Electric", "Mecanic", ect. 

I would like to show the total of "X" for each topic in one graphe, like the exemple below. 

 

My data : 

GabrielActemium_0-1660831587174.png

 

What i would like to have : 

GabrielActemium_1-1660832125083.png

 

What i have in PBI : 

GabrielActemium_2-1660832212629.png

Can you help me set up the graph so that it displays correctly?

 

Have a good day 🙂

 

 

2 REPLIES 2
GabrielActemium
New Member

Thanks for the answer ! 😉 

 

I unpivot the "Electric" column, and i don't enderstant the result : 

 

Even where there is no "X", PBI wrote "Electrique". 

 

Do you know where the problem come from ? 

 

GabrielActemium_0-1660840632830.png

 

davehus
Memorable Member
Memorable Member

Hi, @GabrielActemium , In Powerquery stage you have the ability to unpivot the data into a table. That way you can get the result you require. See this blog for more info. https://databear.com/power-bi-pivot-and-unpivot-columns/

 

Did I help you today? Please accept my solution and hit the Kudos button.

 

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.