Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Discrepancy Between Individual and Total Values in Power BI Service Report

  The report works correctly in Power BI Desktop, but it shows value errors in the Service. In the above picture, the "issue" column shows significantly different values for the individual dat...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Remember that the Power BI Service runs on UTC timezone.  Their June 4 is most likely not your June 4 especially if you use datetime columns

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Thank you for the good answer. However, if that were the problem, the other column value (current year amount) next to it should also be incorrect, but that value matches the actual amount correctly.

    The issue is that the previous year's amounts are displayed correctly by date in the actual table, but the total suddenly includes data for dates from June 5 to June 30, which are not in the slicer.