Forum Discussion
Dont summerise not working
- Anonymous1 year ago
Hi, Yodash
I am glad to help you.
Some visuals such as Line Chart visual, Stacked column chart visual, etc. that have a Y-axis are required to use aggregated values by default. Even though you have set the field don't summarize.
If you want him to display according to the original value, then you have to make sure that the value of your Time field is unique, so that even if you use summarize, the calculation is actually still the original value:
But if your Time field is not unique, he will do a sum calculation for the same Time value:
At this point adding an ID field as a unique value for each row and dragging the ID to Legend will show each data point, but will not show the trend of the data directly:I've attached the pbix file for this little example below, I hope it helps.
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, Yodash
I am glad to help you.
Some visuals such as Line Chart visual, Stacked column chart visual, etc. that have a Y-axis are required to use aggregated values by default. Even though you have set the field don't summarize.
If you want him to display according to the original value, then you have to make sure that the value of your Time field is unique, so that even if you use summarize, the calculation is actually still the original value:
But if your Time field is not unique, he will do a sum calculation for the same Time value:
At this point adding an ID field as a unique value for each row and dragging the ID to Legend will show each data point, but will not show the trend of the data directly:
I've attached the pbix file for this little example below, I hope it helps.
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks, that really helped!