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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. 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.

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.