I am not able to disable Don't Summarize in Powerbi

[SusmitaDas]

I am using the latest version of PowerBi. Whenever I am dropping any value in Y Axis, it is automatically converting to Count. Now before commenting, here are few things:

1) I Do not have Don't summarize option to disable that.

2) Don't Summarize option is already selected in the modelling tab.

3)I've selected "No calculation" as well. Still doen't work.

Please guide me as I am working on a very important project and Don't summarize option is really creating chaos.

Thanks in advance

[v-jingzhang · Accepted solution]

Hi @SusmitaDas 

It doesn't provide "Don't summarize" option because this is a line and clustered column chart. In this visual, the y-axis field must be aggregated. And for all column and line chart visuals, they require aggregated values. Only Table visual and Multi-row Card visual have "Don't summarize" option in Fields well. This is by design. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[Anonymous]

Thank you very much for your answer ..is there any custom visual that I can import for bar, pie chart which does not aggregate values...I am new to PBI and its really creating choas

[SusmitaDas]

I mean to say Enable Don't Summarize in the title