As you can see form below screenshot that my column is uncategorized & Don't summarize. In "Line & Clustered Column Chart" when i drop this column in Column values. i get options of SUM, Min, MAX etc.....
Even though it is "Don't summarize" i shouldn't see options SUM, Min, MAX etc.....
The solution that i am looking for is to display exactly same values as shown below on chart.
Please help me how to do that. Any help is greatly appreciated.
You really need to provide more details here.
A chart has two dimensions...
The values need to be aggregated by whatever you are using as your X-Axys.
What are you using as the X-Axys?
what are you trying to achieve?
Can you draw an example?
This is because you are throwing it into a chart. It has to be a calculation then. An aggregation or a min or max. But be aware though. When you plot it a sum in a chart the calculation is dependent on what you have on the x-axis (unless you use ALL() in your calculation).
Maybe you can provide some more context, so I can help you out.
I'm having the same problem. Why does displaying it in a chart require a calculation? Is there no simple way to visually display things in a chart without this calculation? We are simply trying to plot x and y, it should be that simple.
Thank you for your all reply.
I agree with Alex.
I have already shown data in my screenshot. i just wantto display that data as it is without calculation. there has to be way out or workaround?
You may add an index column in Query Editor and drag that to shared axis field.
Index column didn't helped. it might have some purpose but not helping me what i want.
Its very simple. i want to display value without calculations, is there work around?
Thanks for all replies but not seeing solution how to resolve not summarization of value.
Please see the data screenshot in my question and please help me to understand that how hard it is to represent data as it is without summarization.
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.