Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am trying to build the ability to see changes in my data over time. While I know that this day-by-day filter would work as a slicer list, there are a ton of dates - so the list would be really long and not very user friendly.
Instead, I would like a filter timeline where the user can slide the tick mark left/right to select the date. The left/right limits would be the first/last date of a specific filter data field. I would like it to default to the "latest" date, but then the user could slide the tick mark to see the data based on a different single date.
Basically, I want the the same kind of slicer as the "between" option - but only want a single date AND only want the "tick stops" at the available dates. So if I have dates of 10/1, 10/6, 10/11 - I don't want to have the tick stop at the dates in between.
Possible?
This is a bit of a hack but...
Step 1. Create a date slicer, then use the dropdown to select "Before" (make sure "Slicer header" is visible), this creates a set of dates that ends at a certain time. You could also select "After" but, in Step 3 below, you'll need to use "Bottom" instead of "Top".
Step 2: Create a measure that selects distinct dates. For example, I defined mine as:
Distinct Dates = DISTINCT([MyDateField])
Step 3: Select the visual that we want to use a specific date on. Create a filter on the date field ([MyDateField] in my example) with the following settings:
"Filter type" = "Top N"
"Show items" = Top 1
"By value" = distinct date measure ("Distinct Dates" in my example)
One issue is the slicer's slider still shows a range of dates ending at your "Before" value but hopefully the users can get used to that. I haven't figured out a way to re-format that.
This solution worked for something I have been working on. Basically, created a date picker thanks to the wonderful Guy in a Cube video and needed to filter the corresponding data in the visuals to only the single value showing. Your solution worked. Thank you!
Hi @RGG
I have read through your requirements. Currently, you could use date as a slicer,
with the "between" type, you could slide the tick mark left/right to select the date, but the first/last date should be items in the date column, it can't be change dynamically. you may use another slicer to change the date range in this slicer.(please note that, you need edit interaction on visuals of the same report page.)
As for the "tick stops" at the available dates, it is impossible currently.
You may add some ideas here to help improve power bi.
Best Regards
Maggie
Well, not a great solution but you could hack it with a line chart with categorical x-axis and turn on markers.
Yeah, it doens't look like that functionality to use dates as a dimension for a slider exists within Power BI.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |