How to display data from several columns in a graph?

[GabrielActemium]

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 : 

What i would like to have : 

What i have in PBI : 

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

Have a good day 🙂

[GabrielActemium]

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 ? 

[davehus]

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.