cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
stevemenke Frequent Visitor
Frequent Visitor

Can't get x-axis date to include no data without including all dates in year due to heirarchy

I have a data series that has gaps for some months. I would like the x-axis to include a specific date range that includes some gaps. However, when I choose a the show items with no data on the date heirarchy it includes all dates within any the entire year. For example, I have a date filter from July 1 2016 to July 1 2017. It will include all of 2016 but I only want it to include the specified date range. I have attached an example picture.

 

Screen Shot 2017-11-20 at 8.46.17 AM.png

 

Are there any work arounds? I have tried converting the dates to strings, but then the gaps don't show up because it does not know it is continous.

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-qiuyu-msft
Moderator

Re: Can't get x-axis date to include no data without including all dates in year due to heirarchy

Hi @stevemenke,

 

You can create a calendar table, with Date, Year, Month columns. Then create a chart, drag Year and Month columns from Calendar table to the X axis. Put calendar table Date column in a slicer visual. See: 

 

q2.PNG

 

 

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 REPLIES 5
Moderator v-qiuyu-msft
Moderator

Re: Can't get x-axis date to include no data without including all dates in year due to heirarchy

Hi @stevemenke,

 

You can create a calendar table, with Date, Year, Month columns. Then create a chart, drag Year and Month columns from Calendar table to the X axis. Put calendar table Date column in a slicer visual. See: 

 

q2.PNG

 

 

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
stevemenke Frequent Visitor
Frequent Visitor

Re: Can't get x-axis date to include no data without including all dates in year due to heirarchy

That worked. I originally tried the same thing but I was using the String month which would not sort properly.

 

Thanks!

Highlighted
zgoldenfeld Frequent Visitor
Frequent Visitor

Re: Can't get x-axis date to include no data without including all dates in year due to heirarchy

Is there a way to do this with the string names of the months? Like "Jan", "Feb" ?

zgoldenfeld Frequent Visitor
Frequent Visitor

Re: Can't get x-axis date to include no data without including all dates in year due to heirarchy

stevemenke Frequent Visitor
Frequent Visitor

Re: Can't get x-axis date to include no data without including all dates in year due to heirarchy

You link did not work. Can you please try again?