Forum Discussion
Cannot Show Value as is
Is this a measure or a field on the table? what type of visual you are using?
thanks for the reply.
These are fields in the table that I have categorized as whole number (population, age, median income).
Bar chart.
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.
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.