Date axis to show all values but only within relevant range of dates

[bamber]

Hi,

Is there a way to have the date axis in line or bar chart show all dates between min([date]) and max([date]) of filtered subset but not dates on the either side of this range?

What I did here:
1. Put a date column from date table covering 2020-01-01 to 2021-12-31 on x axis

2. Ticked 'show items with no data' 

3. Using a slicer based on an entirely different column, selected rows with date values within a two small ranges in the middle of this larger period.

The visual is showing the entire two-year date axis anyway, most of it with no data. This might be acceptable when aggregated to months but makes it quite useless when I drill down to days (I have to to scroll sideways to find the relatively small range occupied by factual data).

[lbendlin]

@bamber One way would be to change the x axis to use the fact date rather than the calendar date.  That is not a good way.

Another way is to use zoom sliders.

[bamber]

Hi @lbendlin ,

thanks for the reply. I thought about zoom sliders but wouldn't it leave the user with the same problem: how to find the narrow date range with actual data on an axis that covers two whole years?

[lbendlin]

Find a test user, let them try it, and then decide.