How to do static on x axis and start with april to mar according to Fiscal year

[carade97]

i want x axis is static to 12 month 

and it will begin with apr and end with mar

but

now, this is what it happen when i click fy23

it show jan23 to dec23 ( i didnt expect to be that)

and i want my x axis to be static (change only data)

i dont know how to do it

i want concept, please help

[mahenkj2 · Accepted solution]

Hi @carade97 

Two things you have to do:

1. To make sure X axis is always populated, tick this:

'Show items with no data'

 Check that x axis is categorical.

2. Create an additional column for sort order. Enter 1 to 12 keeping Apr at 1 upto Dec at 12. Use this column as 'Sort by' column for month of A axis.

Google about both items and you will get through.

Hope it helps.