Forum Discussion

jaime-aaron's avatar
jaime-aaron
Frequent Visitor
8 years ago
Solved

Incremental Values

Good day!   Would like to ask, how to create a incremental value for my horizontal axis?   Scenario: Need to create report of revenue in 50,000 increment. See sample below:    Thanks!   ...
  • v-huizhn-msft's avatar
    v-huizhn-msft
    8 years ago

    Hi jaime-aaron,

    I reproduce your scenario and get expected result. I create the following sample table.



    Then create a Clustered column chart, it will show the first screenshot automatically. If you want to create a incremental value, please right click ellipsis on the right top of chart->sort by Value, you will get the expected result as the second screenshot shown.

    The chart by defaultSort by value ascending

    Best Regards,
    Angelia

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
8 years ago

Hi jaime-aaron,

I reproduce your scenario and get expected result. I create the following sample table.



Then create a Clustered column chart, it will show the first screenshot automatically. If you want to create a incremental value, please right click ellipsis on the right top of chart->sort by Value, you will get the expected result as the second screenshot shown.

The chart by defaultSort by value ascending

Best Regards,
Angelia