Forum Discussion
Value are not the same between table and graph
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 ,
Your idea is correct because different aggregations make different values displayed in the visual object and if you select the same aggregation then they will also display the same values.
In a table, you can choose not to aggregate because it displays the same categories over and over again, as you can see in the following two images.
Whereas in Line Chart, there will be only one point for the same classification, so there is no option of not aggregating.
Therefore, you can choose the appropriate aggregation in line charts or by creating your own measure or calculated columns to show the desired results.
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.