Skip to main content

Power BI

Needs Votes

DAX powered Dynamic Slicer for Default members selection

Vote (11) Share
Michael Shparber's profile image

Michael Shparber on 04 May 2017 13:39:26

Congrats on a new Relative Date Slicer!
Let's make it even more Dynamic.
Instead of limiting the time-steps (years, months, etc.), please give the possibility to write free DAX EXPRESSIONS for the default memeber that the report would be filtered upon opening.
So that I could write even conditional expressions, such as "If today is Saturday, then slice on the last week else show current week".
You can also apply the free DAX-powered default members choosing for all kinds of slicers, not just Dates.
Thanks and good luck!

Comments (2)
Michael Shparber's profile image Profile Picture

Steve Coleman on 05 Jul 2020 23:32:39

RE: DAX powered Dynamic Slicer for Default members selection

I would be in favor of this being baked into the model itself, and not just a slicer.

Michael Shparber's profile image Profile Picture

Ben Gribaudo on 05 Jul 2020 23:32:16

RE: DAX powered Dynamic Slicer for Default members selection

Related: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/19055692-slicer-default-selected-values