Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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?
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

thanks for the reply.

 

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

 

Bar chart.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
    Anonymous
    Not applicable
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

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