Action button for "today" filter

[Anonymous]

I am trying to create a button that would bring a BciCalendar visualization to the current month.

Any tips would be appreciated.

Thanks!

[Anonymous]

I think you are trying to create to create bookmark.

Bookmarks are used for hiding object or storing particular state of visual. Action part just display one state of visual and it will  not filter any data.

https://docs.microsoft.com/en-us/power-bi/desktop-bookmarks

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.

[Anonymous]

Hi,

My understandign of bookmarks is that they bring your dashboard to a specific state. However, I am trying to bring my dashboard to "today()" date, which changes daily. Do you have any feedback on how to make a bookmark of that sort?

Thanks!

[Anonymous]

@Anonymous 

One thing you can do is add a statement in each of your DAX statements that default to Todays date. So if no date filter is being applied, all of your measures will default to today. It would look something like this:

Measure = 
VAR today = SELECTEDVALUE( Calendar[date], TODAY())
RETURN
CALCULATE(
SUM( table[column],
calendar[date] = today)

As far as I know, there's not a button you can press to go to today like a bookmark.  

Edit: Actually, now that I think about it, if you add a bookmark that clears all date slicers, it would technically be bringing the data to today if you do the above.

[Anonymous]

In dashboard create one visual as per your requirement. And set filter in it to today. Whenever you click on button it needs to show that visual only which is having calculations based in today()

Thanks,
Pravin