date axis
1 TopicDate axis to show all values but only within relevant range of dates
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).1.6KViews0likes3Comments