Combining Multiple Sum 'Value Sets' into One Column

[Intheknow109]

I'm new to Power BI and I need to combine these two columns to show in a graph together. Your help would be greatly appreciated!

[speedramps]

@Intheknow109 

Please can you you accept my solution.

You have accepted @v-agajavelly  as a solution,

which is unfair because they have not solved the problem. 

I did !

The "v-" accounts are annoying because they keep doing this.   

Thank you

[pankajnamekar25]

Hello @Intheknow109 

try this

In Power Query Editor

Select the C and D columns.

Go to the Transform tab.

Click Unpivot Columns.

Thanks,
 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

[v-agajavelly · Accepted solution]

Hi @Intheknow109,

We would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.
Regards,
Akhil.

[speedramps]

If you are new to Power BI then learn about "data types".

For example text, whole numbers, decimals, dates and times.

A hour data time can only contain a maximum of 24

a minute data type can only contan a maximum on 60 

So do not use hour and minute data types for problem.

Create a whole number data type called "Minutes" that = (HH * 60) + MM

Then use "minutes" to draw your graph/

Please clcik the thumbs up and [accept solution button]. 

 Thank you !