Issues in relative filter to show next six months

[Anonymous]

In this screenshot i used relative filter to show next six months of datas. In that i want to show no data in a month also so i give no  data enable also..this Tile shown correctly but the issue is i dont want to see the previous Month names in X axis i want to see today to next 6 month only......Any help is from anybody is always welcome..

[Pragati11 · Accepted solution]

Hi @Anonymous ,

Can you try moving Year along with Month on your x-axis?

Then when you apply relative date filtering, it will filter x-axis also.

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

Thanks,

Pragati

[Anonymous · Accepted solution]

@Pragati11 

hi,

I already tried with that kind of method by year  along with Month on x-axis

but it didnt give accurately..

[Pragati11 · Accepted solution]

Hi @Anonymous ,

Can you try moving Year along with Month on your x-axis?

Then when you apply relative date filtering, it will filter x-axis also.

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

Thanks,

Pragati

[Anonymous · Accepted solution]

@Pragati11 

hi,

I already tried with that kind of method by year  along with Month on x-axis

but it didnt give accurately..

[Pragati11 · Accepted solution]

Hi @Anonymous ,

Looking at your screenshot, the chart looks right with correct MONTH-YEAR values on x-axis, based on the selection you have made in relative date filter.

You are seleceting NEXT 6 MONTHS from TODAY: this should June 2020 to November 2020. This is what is shown on your chart.

What you are thinking it is wrong?

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

Thanks,

Pragati

[amitchandak]

@Anonymous , Couple of reasons

1. Your formula has used +0

2. Your filter on the date and date on-axis is different

[Anonymous]

@amitchandak 

hi,

I didnt use any formula to filter that...