topic Action button for "today" filter in DAX Commands and Tips

Action button for "today" filter

Anonymous — Wed, 19 Feb 2020 18:09:54 GMT

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

Any tips would be appreciated.

Thanks!

Re: Action button for "today" filter

Anonymous — Thu, 20 Feb 2020 10:14:43 GMT

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.

Re: Action button for "today" filter

Anonymous — Thu, 20 Feb 2020 16:52:19 GMT

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!

Re: Action button for "today" filter

Anonymous — Fri, 21 Feb 2020 02:24:57 GMT

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.

Re: Action button for "today" filter

Anonymous — Fri, 21 Feb 2020 03:42:11 GMT

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