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.
Thank you so muxh, it worked well done! v-yalanwu-msft