Forum Discussion
Combining Multiple Sum 'Value Sets' into One Column
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!
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.
4 Replies
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 !
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.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 | LinkedInIf this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
Please can you you accept my solution.
You have accepted Anonymous 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
