Forum Discussion
Discrepancy Between Individual and Total Values in Power BI Service Report
Super UserCheck your data model. Make sure your slicer is fed from a dimension table or a disconnected table, not from the fact table.
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
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