Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don'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.

Reply
Mumiah
Frequent Visitor

Value from table changes when displayed on Visual

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 Mumiah_0-1677030140750.png                   

Fig.2Mumiah_2-1677030241219.png

 

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

Mumiah_6-1677031382850.png

But even then if I try to make it a whole number it seems the I row dows not round the .5 either 

Mumiah_9-1677031601264.png

 

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. 

Mumiah_0-1677030140750.png

 

1 ACCEPTED SOLUTION
Mumiah
Frequent Visitor

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.

View solution in original post

3 REPLIES 3
Mumiah
Frequent Visitor

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.

amitchandak
Super User
Super User

@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

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

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.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.