Forum Discussion

dgwilson's avatar
dgwilson
Resolver III
8 years ago

Automatically change/set filter selection

Hi there...   I start my Power BI dashboard by showing users a page that I call "Select". It's primary purpose is to allow users to use a filter that shows a series of end dates. i.e. 1st July, 7th...
Need Help
dgwilson's avatar
dgwilson
Resolver III
8 years ago

Interesting. Indeed selecting data for the last week works. Spot on.

 

The challenge comes when I want the user to select the week before that... Selecting data for the last 2 x weeks isn't as nice and the dashboard shows duplicate entries per customer.

 

So for useability... I return to wanting to magically (via DAX?) select the last entry in a list of dates.

 

- David

edhans's avatar
edhans
Community Champion
8 years ago

 

So for useability... I return to wanting to magically (via DAX?) select the last entry in a list of dates.

 

You cannot use measures as slicers, and DAX are like Excel functions. They can report data, but they cannot change anything in the file like VBA could., and there is no VBA in Power BI. At this point it might be a USERVOICE request to have slicers preset to certian data based on criteria.