Forum Discussion
Keep the hours over 24
Hi,
I'm trying to convert the working and idle time into power query, but somehow it cant show the exact value from my excel file.
For example below, i want the 109H 30Min shown in my Power BI. So that i can make stacked bar chart with percentage of each month.
Can someone help me?
Hi, Anonymous ;
The main reason for this problem is that you need to create a new column in Excel because of the automatic conversion of excel formats:
=B2*24Then it will change the hour times ,you could convert in power query.
The final output is shown below:
Or better yet, use the formula directly in Excel to convert it to the format you want and import it into PowerBI
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- amitchandak
Super User
Anonymous , I doubt you can show time on Y-axis or in this format.
v-yalanwu-msftCommunity Support
Hi, Anonymous ;
The main reason for this problem is that you need to create a new column in Excel because of the automatic conversion of excel formats:
=B2*24Then it will change the hour times ,you could convert in power query.
The final output is shown below:
Or better yet, use the formula directly in Excel to convert it to the format you want and import it into PowerBI
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.- v-yalanwu-msft
Hi， Anonymous ；
Is your problem solved?? If so, Would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
