Cannot Show Value as is

Question

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.&nbsp;How to not aggregate?

anonymous · Answer

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

anonymous · Answer

thanks for the reply.&nbsp;These are fields in the table that I have categorized as whole number (population, age, median income).&nbsp;Bar chart.

anonymous · Answer

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 · Answer

I would like it to not aggregate data when I select Show Value As no calculation.&nbsp;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.&nbsp;What is the purpose of Show Value As no calculation, since it does not stop the aggregation?&nbsp;&nbsp;&nbsp;

anonymous · Answer

"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.&nbsp;would it be possible to share a snippet of how your data looks like and expected results.

Forum Discussion

Cannot Show Value as is

6 Replies

Related content

Show Latest Value & Last N Values

Show only selected Company value

Show Maximum value?

show values for all

Map not showing any values