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 Anonymous and Ritaf1983
Thank you to both of you for your answers
Yes I think unfortunately a dedicated column or calculated column has to be created...
I still does not understand why Power BI can not apply the agregation on the axis mentioned. In my case this in simply city and date.
Is it a bug to raise to Microsoft or is not 'normal' such behaviour ? For me, who use other tools such as SAP BI, Cognos, etc, this is surprising.
Actually, understanding your answer, it means I should create a column (or measure ?) having which syntax ?
Is is calculate, averagex ?
I must admit being a little bit lost.
Thanks in advance.
Best regards,
Gaetan
Hi gaetangoumaz
This is not a bug; it's the logic of how the engine works. I can understand the confusion between when to apply aggregation to the graph, when to use a calculated column, and when to use a measure. It's important to fully understand the tool to "swim" through it with ease.
For your current needs, I'd be happy to try and help, but I need to better understand the data you have and what you're trying to achieve. This is why I recommended creating a small 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.
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.
Thank you so much Ritaf1983 for your reactivity.
I have tried to recreate a small and dedicated small model with sample data, but in that case (few rows), it works :(.
Actually I try both : Improve my 'sample' model in order to reproduce the case and then should be able to send it to you. And in parallel, I am trying to understang and solve the problem.
I have made som tries and few syntaxes, but I am not expert in DAX :(.If this behaviour seems 'normal' to you, which syntax will you try on your side (column or measure ?) ?
Should I give explicitly the axes (in my case, the city and date) - even if I thought that Power BI will be quite clever to do it itself on a graph as it make it for the table ?Thank you so much in advance.
Regards,