All Dates on x-axis showing for Date Table - can't filter

[datastrategy]

I can't filter the dates on my x-axis... my Date Table has all dates from 1/1/2019 to 12/31/2019.  I have data for sales this year, but December keeps showing up in my x-axis, even when filtering by "relative last 12 months."  The only way to get rid of December is draggin Date - Month to the filter and taking off December.  Know why this could be the case?  The data filters if I change the date, but the actual axis still shows the full year dates for the x-axis.

[VasTg]

@datastrategy 

Do you have a relationship defined between date and sales table? If so, try the filtering to both direction.

If this helps,accept it as a solution.

Kudos are good too.

[datastrategy]

That still didn't work.  See screenshots below.

[Anonymous]

Hi @Anonymous can you upload a snapshot of your chart or data model?

[datastrategy]

See attached.  creating a "both" filter didn't work. 

[VasTg]

@datastrategy 

I tested this and it works as expected for me.

I created a Date table with DAX.

Date = CALENDAR(DATE(2019,01,01),DATE(2019,12,31))

I created a mockup fact table with this data.

TransDate	Value
01/31/2019	100
02/28/2019	200
03/31/2019	300
04/30/2019	400
05/31/2019	500
06/30/2019	600
07/31/2019	700
08/30/2019	800
09/30/2019	900
10/30/2019	1000
6/26/2019	-800
10/1/2019	-400
1/31/2019	150

Defined a relationship between Date and fact(Single direction filter ; 1 to many) and i don't see November and December in the bar chart.

What are the other metrics you use in that chart? Share a sample dataset to better answer your question.

It this helps, mark it as a solution.

Kudos are good too.

[datastrategy]

I figured out my problem.  On one of the measures if there were no costs (to calc profit) it said If blank, then 0, or "value" .... the 0 was making a placeholder in the date axis.  so I changed that to if blank then blank otherwise the value!  

Sorry for confusion.  The zero value was adding the other months!

[datastrategy]

How do I just share a sample of the data?  I have measures that might be affecting this probably?