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.
Hi,
For some time I have been looking for a solution how to do something like this in Power BI:
Have you ever come across this to have a filter (not in the filters pane, but a filter in the report) where you can choose the hour, minute and date as an option between two dates?
I don't know how can I make the option between hours and minutes of power filtering e.g.
from 2020-01-09 03:15 to 2020-02-10 06:08
I have two separate tables with the date and time in my model.
When i add hours and minutes to one slicer i only have a list and dropdown options and i can't add two separate slicers which will only be a list because it won't work as an option between them.
Do you know how i can:
1. Add hours and minutes to one slicer at the same time
2. do the second, analogous to the first slicer -> if I have the first points I'll do the same
3. How to set these two slicers as an between option
I think the best way to do that would be to add disconnected date and time tables to your model, use those in your slicers, and then harvest the values from those slicers to be used in your measure(s). The measure could be used in a page filter, so that you could filter the whole page at once (depending on your model).
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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 |
---|---|
111 | |
94 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |