Limit Months in x Axis to Current Month

[yasbos]

I can't figure out why the X axis shows September, to December, when I have no data for them in my table. I should see the graph from Jan to August only. I looked in the advanced filtering, but it doesn't give me useful criteria. Any help would be appreciated.

[Anonymous]

@yasbos 

Is the Month in X axis coming from a dim Calendar table not your fact table? You can add a column there to limit it to the current month, then add as a visual level filter.

[yasbos]

Thanks so much, @Anonymous . Yes, indeed, it's coming from a dim table. I'm not sure, though, that I understand your solution. Thanks so much.
P.s. I'm going to sleep  now, so I probably won't see any responses until a few hours later. 

[Anonymous · Accepted solution]

Hi @yasbos 

Not sure if you generate the Calendar table by CALENDARAUTO, you can limit the Calendar to end at the Max date of your fact table if you want to. Or go to your current Calendar table, add a column like IF([Month]<=MONTH(yourFactTableMaxDate), 1,0)  -  just explaining logic, then use this column as a filter.

[yasbos]

Thanks @Anonymous
That works, but, you see, what is mind boggling is that everything works fine on another graph that uses this same calendar table but with another fact table!!