BEGGING FOR HELP

[Anonymous]

Hi, 

I asked a few times before and I want to try one more time to get for help. I am kind of new with Power BI. I need to create buttons to change time period on the page for tables. Here is what it must be look like buttons.

Here is my data.  Requirement is when the user clicks on button (12 hours or 24 hours etc) other tables on the page should be updated with this period. Please even sharing video ir anything will help. Please.. Looking forward to hearing. Thank you

[v-yalanwu-msft · Accepted solution]

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.

[v-yalanwu-msft · Accepted solution]

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.

[Anonymous]

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.

[Anonymous]

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.

[v-yalanwu-msft · Accepted solution]

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]

Thank you so muxh, it worked well done! @v-yalanwu-msft 

[JR-DCPS]

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.

[Anonymous]

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 

[amitchandak]

@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

[Anonymous]

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 ?