Forum Discussion
Value are not the same between table and graph
- 1 year ago
Hi gaetangoumaz
Unfortunately, I can't assist at this stage because I still don’t fully understand your data structure and what you are trying to accomplish. The most I can do is share a dummy file I use for demonstrating solutions. You can try to create something similar to what you need in that file, including the desired result.
If you manage to do so, please save it in a public cloud service and share it via an open link.
Hi gaetangoumaz
The difference in values between your table and graph is likely due to how aggregation is applied. Based on your images, it seems the table uses a single layer of data, whereas the graph appears to have a hierarchy. This difference means that aggregation behaves differently because the context changes, causing discrepancies.
Graphs in Power BI always require some form of aggregation (like a pivot table in Excel), even when tables can show individual values without it. This is why you're seeing different numbers; the graph aggregates based on the hierarchical context, which doesn’t match the table.
To better assist with resolving the issue, it would be helpful to see the PBIX file in English with the data structure you're working with, along with a clear example of the desired outcome. I recommend creating a dummy version of your report (without sensitive data), saving it on a public cloud service (like OneDrive, Google Drive, or Dropbox), and sharing a link. This will make it easier to understand the exact problem and provide more specific guidance.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly