Data shows differently after publishing to service

[cuibolun]

Hi, 

When I publish a report and open it to pbi service, it shows exactly the same result, however, if I refresh the page or after close-reopen the browser, it shows negative value. Any reason why?
This is the orginal view:

After refreshed the browser: 

Thank you!

[Greg_Deckler]

@cuibolun Try resetting the report to default maybe? It's an option in the report ribbon in the Service.

[cuibolun]

@Greg_Deckler It happends after I refresh the dataset in service as well. It doesn't happen if I refresh using desktop. @

[Greg_Deckler]

@cuibolun You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

[cuibolun]

@Greg_Deckler  I think I found the root of the issue, these number are from calculated column, when I refresh the dataset in server (datasource is from Azure SQL), some of the calculated fields shows incorrect value (they should be positive). For example, 

the right column is orginal data, the left column is calcuated column. The formula that I use in this calculated column is :

Duration (Hrs) =

DIVIDE(

DATEDIFF(

    Starttime,

    Endtime,

    MINUTE),60)

Any idea?

Thank you!

[cuibolun · Accepted solution]

Problem solved after I move the calculation from DAX to Power Query. (so... sort of fixed?)

[Greg_Deckler]

@cuibolun Would have to see your DAX

[cuibolun]

@Greg_Deckler I have two datetime attributes (start and end), then I used these two fields to calcuate the duration in hours (trying to avoide rounding so use minutes and divide by 60):

Duration (Hrs) =

DIVIDE(

DATEDIFF(

    Starttime,

    Endtime,

    MINUTE),60)

So the left is the calcualted value and right is the original duration out of the data source.

[Greg_Deckler]

@cuibolun You can simply subtract them. No need for DATEDIFF. Date and Date/time values are simply decimal numbers where the integer portion is the number of days since 12/30/1899 and the decimal portion is the fraction of a day 24/60/60.

[cuibolun]

Hi @Greg_Deckler 

Tried but not working. 😞