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
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Thank you for your interest and for leaving a comment.
The slicer I use is created with the date values from a separate calendar table, not directly from the Fact table's dates. I heard that this is necessary to use time intelligence functions. However, the issue I'm facing is that when I select the last date in the Fact table, the previous year's same month's data gets converted to the end of that month, not up to the selected date.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523