Skip to main content

Power BI

New

DAX powered Dynamic Slicer for Default members selection

Vote (7) 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

982b9340 2249-4092-be16-48163ec15e6a 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

394a88ba 716c-4e75-8a2e-6fd41c37499e 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