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.
Anonymous , Can you give this data in table /text format. Also what is expected when a filter is selected.
If this is based on today and now you need to add measure in visual (or all the measures should follow the filter like one added below) , or use these measures as filter in the visual level filter
last 12 hours = Countrows(filter(Table, Table[EndtimeET] <= Now() && Table[EndtimeET] > Now() -time(12,0,0)))
last 24 hours =
Countrows(filter(Table, Table[EndtimeET] <= Now() && Table[EndtimeET] > Now() -1))
This month =
Countrows(filter(Table, Table[EndtimeET] <= eomonth(today(),0)= eomonth(Table[EndtimeET],0) ))
You need to use bookmark button of you need measure slicer for this
bookmark -https://blog.crossjoin.co.uk/2018/04/20/dynamically-changing-a-chart-axis-in-power-bi-using-bookmarks-and-buttons/
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
measure slicer
https://www.youtube.com/watch?v=b9352Vxuj-M
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern
Hi amitchandak,
I tried to share data with pbix but the file type is not supported, I do not know why. Is there anyway I can share it with you ?