Incremental Values

[jaime-aaron]

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 · Accepted solution]

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