Forum Discussion
Cannot Show Value as is
I want show have some values without aggregation. It defaults to Count. I select Show Value As then without calculation but nothing changes. I can select Sum, Average, etc. How to not aggregate?
"Show value as no calculation" doesnt affect Aggregation, this only controls how the final value of your axis value is shown in the visual, either as a percentage of the overall, or without calculation. It is "Don't Summarize" what you need.
would it be possible to share a snippet of how your data looks like and expected results.
I have published it. https://app.powerbi.com/groups/me/reports/f0a23657-424e-4459-a46b-bf5a937295ce/ReportSection
The workaround is to average the population but that should not be necessary.