Forum Discussion
Cannot Show Value as is
I would like it to not aggregate data when I select Show Value As no calculation.
My data includes population, age, and income values. A bar chart on city and any of those values does not work as expected. Power BI forces aggregation, even though I default to not aggregate, and select Show value As no calculation.
What is the purpose of Show Value As no calculation, since it does not stop the aggregation?
"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.