The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
77 | |
71 | |
47 | |
39 |
User | Count |
---|---|
136 | |
108 | |
70 | |
64 | |
57 |