Forum Discussion
BEGGING FOR HELP
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.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.
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.
Hi v-yalanwu-msft , thank you so much your helpful reply! I made a progress with your solution but I wonder if we have 2-3 or 4 tables on this report page and we want to update them this time period limitation so how e are going apply it ? Looking forward to hearing your help.
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.