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 ...
Need Help
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.

    • daytripper's avatar
      daytripper
      Frequent Visitor
      8 years ago

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