- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:
Best Regards,
Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:
Best Regards,
Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Is there a way to do this with the string names of the months? Like "Jan", "Feb" ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You link did not work. Can you please try again?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
That worked. I originally tried the same thing but I was using the String month which would not sort properly.
Thanks!

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
07-17-2024 02:31 PM | |||
Anonymous
| 05-29-2023 08:17 AM | ||
Anonymous
| 12-04-2023 10:21 AM | ||
12-12-2023 03:21 AM | |||
06-30-2023 07:24 AM |
User | Count |
---|---|
141 | |
115 | |
84 | |
63 | |
48 |