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

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

  • 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?