Cannot Show Value as is

[Anonymous]

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?

[Anonymous]

Is this a measure or a field on the table? what type of visual you are using?

[Anonymous]

thanks for the reply.

These are fields in the table that I have categorized as whole number (population, age, median income).

Bar chart.

[Anonymous]

PowerBI automatically aggregates your data if more than one value in one axis exist for the other axis.

tell us more about your scenario so we can help you.

[Anonymous]

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?

[Anonymous]

"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.

[Anonymous]

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.