Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Fixed Time Buttons for Table

Hi, 

 

Could you help me how I can create this buttons on the picture? Basically, the requirement is when you click on the button on the report page, table should be updated with the selected option.  For instance, when clicking 24 hours, the table should be updated with last 24 hours data.  

 

 

Thank you, 

Yavuz

 

P.S. I can provide more information if needed

General Comment
Need Help
Show and Tell
Tips and Tricks
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    Hi Anonymous,

     

    May be you can try use the slicer like the following :

     

    If this ok, create a measure as a dynamic tag and let it in filters pane.

    Measure = 
var _2hours = NOW()-TIME(2,0,0)
var _12hours = NOW()-TIME(12,0,0)
var _24hours = NOW()-TIME(23,59,59)
var _weekhours = NOW()-TIME(23,59,59)*7
var _month = NOW()-TIME(23,59,59)*30
return
SWITCH(TRUE(),
SELECTEDVALUE(Button[button])="2 hours",_2hours,
SELECTEDVALUE(Button[button])="12 hours",_12hours,
SELECTEDVALUE(Button[button])="24 hours",_24hours,
SELECTEDVALUE(Button[button])="week",_weekhours,
SELECTEDVALUE(Button[button])="month",_month,TIME(0,0,0))

Measure 2 = IF(SELECTEDVALUE('Table'[DateTime])>=[Measure],1,BLANK())

     

     

    If you want use button, bookmarks and slicer are used in combination. Bookmarks are linked to the specified slicer.

     

    Pbix in the end you can refer.

    Best Regards

    Community Support Team _ chenwu zhu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

9 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

       

      Thank you for replying. Here is my data if it makes more sense for help. I do not think Bookmark and button works for it. I know how to use bookmark and blank button, please can give me more specific idea  or other options ? 

       

  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    Community Support
    4 years ago

    Hi Anonymous,

     

    May be you can try use the slicer like the following :

     

    If this ok, create a measure as a dynamic tag and let it in filters pane.

    Measure = 
var _2hours = NOW()-TIME(2,0,0)
var _12hours = NOW()-TIME(12,0,0)
var _24hours = NOW()-TIME(23,59,59)
var _weekhours = NOW()-TIME(23,59,59)*7
var _month = NOW()-TIME(23,59,59)*30
return
SWITCH(TRUE(),
SELECTEDVALUE(Button[button])="2 hours",_2hours,
SELECTEDVALUE(Button[button])="12 hours",_12hours,
SELECTEDVALUE(Button[button])="24 hours",_24hours,
SELECTEDVALUE(Button[button])="week",_weekhours,
SELECTEDVALUE(Button[button])="month",_month,TIME(0,0,0))

Measure 2 = IF(SELECTEDVALUE('Table'[DateTime])>=[Measure],1,BLANK())

     

     

    If you want use button, bookmarks and slicer are used in combination. Bookmarks are linked to the specified slicer.

     

    Pbix in the end you can refer.

    Best Regards

    Community Support Team _ chenwu zhu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thank you so much v-chenwuz-msft ! This is exactly what I was looking for it! Great job! I can not enough thank you.  Sending file amazing! Please do you mind if you create a short fast video for me, however you did this two pages? I will be so happy.  I am still learning Power BI and I am getting better. Please do it for me even if you do not want add voice or speak its totally fine, just I like to see to how did all steps.  Looking forward to hearing from you. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thank you, v-chenwuz-msft again. I opened your file and started to create Button table. Now, I am on to write DAx formulas but my question is should I select my value from table when writing Selected Value. 

      Measure = 
var _2hours = NOW()-TIME(2,0,0)
var _12hours = NOW()-TIME(12,0,0)
var _24hours = NOW()-TIME(23,59,59)
var _weekhours = NOW()-TIME(23,59,59)*7
var _month = NOW()-TIME(23,59,59)*30
return
SWITCH(TRUE(),
SELECTEDVALUE(Button[button])="2 hours",_2hours,
SELECTEDVALUE(Button[button])="12 hours",_12hours,
SELECTEDVALUE(Button[button])="24 hours",_24hours,
SELECTEDVALUE(Button[button])="week",_weekhours,
SELECTEDVALUE(Button[button])="month",_month,TIME(0,0,0))

Measure 2 = IF(SELECTEDVALUE('Table'[DateTime])>=[Measure],1,BLANK())

       

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      I think this is better and faster way.

      "If you want use button, bookmarks and slicer are used in combination. Bookmarks are linked to the specified slicer." So I created buttons, bookmarks and slicer, but some reason it does not update my table with last 2 hours or 24 hours when I clicked on buttons. Please tell me v-chenwuz-msft  where I missed the point. 

       

      • v-chenwuz-msft's avatar
        v-chenwuz-msft
        Community Support
        4 years ago

        Hi Anonymous ,

         

        More instructions with steps

        1 Create 4 buttons, one slicer and 4 bookmarks.

        on 2 hours bookmark, select '2 hours' in slicer and hide the slicer. update '2 hours' bookmark.

        other bookmarks are same as it. Hide the slier after selecting.

         

        2 Set the action of buttons.

         

        You can refer this video in the end.

         

        Best Regards

        Community Support Team _ chenwu zhu

         

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.