Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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).
@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.
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?
Find a test user, let them try it, and then decide.
User | Count |
---|---|
47 | |
26 | |
21 | |
17 | |
15 |
User | Count |
---|---|
53 | |
34 | |
17 | |
17 | |
15 |