Forum Discussion

TimNYC's avatar
TimNYC
Icon for Helper I rankHelper I
6 years ago

Removed Unwanted Dates from X-Axis

I'm trying to build a report that will show all sales from the previous two weeks through the future two weeks. So the dates range I would like to see on the X-Axis is 6/28 - 8/1 (since today is 7/14...
Need Help
v-deddai1-msft's avatar
v-deddai1-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi TimNYC ,

 

Would you please use show item with no data:

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai

TimNYC's avatar
TimNYC
Icon for Helper I rankHelper I
6 years ago

Thank you for continuing to assist v-deddai1-msft. "Show items with no data" nullifies the measure's filter and causes all dates, from 1/1/2017 - 12/31/2020, to be shown. It also causes July 5 to show up as blank on the table and the cart, instead of as zero. I need all dates that do no contain sales to show up as zero, and for the X-axis to show only the dates 6/28 - 8/2.