Forum Discussion

bil1's avatar
bil1
Regular Visitor
9 years ago

Year axis sum error

hi, 

 

I am new to POWER BI and would like to get some help from you guys, Whenever i try to select any value from YEAR coloum , it automaticly add them up rather than showing year i.e 2013, 2014 on the axis.. 

Need Help

2 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    9 years ago

    Hi bil1,

     

    Did you mean the Year column add up automatically on Y-axis?

     

    In chart, the Y-axis only supports numeric values, and it will be aggregated by default. In your scenario, change the Sum aggregation to Maximum for a test.

     

     

    Besides, make sure that Year column is set to whole number type and didn't come in as Text. Otherwise, all you will get is a Count aggregation for a Text column in your visual.

     

    Thanks,
    Yuliana Gu