Forum Discussion
BEGGING FOR HELP
- 4 years ago
Hi, Anonymous ;
If you use button ,you could use bookmark ,such as:1.create 6 buttons.
2.create three measure.
2hours = var _diff=DATEDIFF(MAX('Table'[DateTime]),NOW(),HOUR) return IF(_diff<=2&&_diff>=0,1)2hours = var _diff=DATEDIFF(MAX('Table'[DateTime]),NOW(),HOUR) return IF(_diff<=2&&_diff>=0,1)24hours = var _diff=DATEDIFF(MAX('Table'[DateTime]),NOW(),HOUR) return IF(_diff<=24&&_diff>=0,1)3.create 6 bookmarks.
2hours:
12 hours:
24 hours:
week:
custom:add other page
4:add action to button.
The final output is shown below:
Or you could use slicer may be more convenient.
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. - 4 years ago
Hi, Anonymous ;
You can set filter, Filter on this visual,not filter on page for each table.
https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-report-add-filter
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Is there a reason you're not creating a filter for the time field? It can handle what you want to do without creating a bunch of bookmarks and extra measures.
It is the requirement that has to be buttons or specific time period filters like on the pict. If you have any idea please feel free to share how you can. JR-DCPS