Chart not being sliced by date

[daytripper]

Hi all...

Hopefully a simple one, but I'm a new user and really stumped...

I have a date slider and a histogram beneath it. When I move the data-start date on the slider, the data disappears from the chart as expected - but the X-axis doesn't 'shorten' to the new date. The result is that I'm left with a yawning gap with no data on my axis. How can I get rid of this gap..?

I've got  the following options activated which may affect the dates:

- Page-level filter to show dates from 2015 onwards (Date table goes back to 2006

- 'Show items with no data' is toggled on, as this is log data and inactive periods in the log need to be illustrated

any thoughts?

thanks!

[v-yulgu-msft]

Hi @daytripper,

Based on my test, for date hierarchy displayed on X-axis, items with no data won't disappear when you change data range on slicer. However, if you change date hierarchy to dates, the gap on X-axis will be invisible automatically. I think this is a by design behavior, currently, it might not able to change it.

Regards,

Yuliana Gu

[Floriankx]

Hello,

I agree to @danextian.

Maybe you could try and built an additional measure.

Measure2:=If([Measure]=0,Blank(),[Measure]), so you can supress 0-Values. Maybe this works.

[daytripper]

will give this a try - thank for the help..!

[danextian]

hI @daytripper,

Is the date column in your slicer the same as the date column in your chart? I'm thinking they're two different but related columns with a single direction filter. 

[daytripper]

Hi @danextian

Thanks for the reply - they are the same Date table in both the slicer & the histogram... 

[danextian]

Hi @daytripper

The measures in the chart are probably returning zero for some months. Please go to Show Data to check.