Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
I'm having this issue where I have a table shown in the Dashboard visual that the Time values differ from what's shown in power query, I think it's doing doing some odd rounding and as a result actually changes the value, it's a little odd to explain but hopefully the images below paint a better picture.
First the expected result is Fig.1. The incorrect result I'm getting on the dashboard is Fig.2, this is almost correct but the row C , I and Total are incorrect. (Note the Total row isn't actually calculated it's a regular value)
Fig.1
Fig.2
The problem I think is there is a rounding that is being done on the visual that's not working properly, so I tried adding steps on Power Query for testing to dupicate the column convert it to Decimal number, and multiply it by 84600 to get the seconds and it would seem if we were to round these numbers this would actually output the correct numbers, even if the format it's displaying is completely not what I need
But even then if I try to make it a whole number it seems the I row dows not round the .5 either
So I'm completely clueless as to how to address, again only reason I added those columns was for testing but what I need is for the dashboard to show the accurate seconds in it's Time format as once again shown below. any help truly appreciated and hopefully it all made sense.
Solved! Go to Solution.
So I was able to actually figure it out, on power query I converted the column to decimal numbers, then multiply it by 86400 and round it, but include "RoundingMode.AwayFromZero" this rounder the .5 up, (used this article Helpful Secrets about ROUNDing in Power Query - Excel Tips - MrExcel Publishing for reference), after it's been rounded, devided it by 86400 and convert it to Time, this looks a lot of steps and would still take a cleaner solution but it just might be a Bi Limitation.
So I was able to actually figure it out, on power query I converted the column to decimal numbers, then multiply it by 86400 and round it, but include "RoundingMode.AwayFromZero" this rounder the .5 up, (used this article Helpful Secrets about ROUNDing in Power Query - Excel Tips - MrExcel Publishing for reference), after it's been rounded, devided it by 86400 and convert it to Time, this looks a lot of steps and would still take a cleaner solution but it just might be a Bi Limitation.
@Mumiah , DAX is not best for duration sum.
Refer these option
Duration
https://radacad.com/calculate-duration-in-days-hours-minutes-and-seconds-dynamically-in-power-bi-usi...
https://social.technet.microsoft.com/wiki/contents/articles/33644.powerbi-aggregating-durationtime-i...
https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?GroupId=547&MessageK...
https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389
So I'm not trying to do any type of sum, nor am I using duration, I'm just trying to get the dashboard visual to show the correct values as in the source file or in the Power Query.
User | Count |
---|---|
117 | |
75 | |
62 | |
50 | |
44 |
User | Count |
---|---|
174 | |
125 | |
60 | |
60 | |
57 |