Forum Discussion

daytripper's avatar
daytripper
Frequent Visitor
8 years ago

Chart not being sliced by date

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!

Need Help

6 Replies

  • danextian's avatar
    danextian
    Icon for Super User rankSuper User
    8 years ago

    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's avatar
      daytripper
      Frequent Visitor
      8 years ago

      Hi danextian

       

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

      • danextian's avatar
        danextian
        Icon for Super User rankSuper User
        8 years ago

        Hi daytripper

         

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

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    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's avatar
      Floriankx
      Icon for Solution Sage rankSolution Sage
      8 years ago

      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.