Skip to main content
Microsoft Idea

Power BI


Dropdown slicer default value from measure

Vote (1) Share
Сергей Капарис's profile image

Сергей Капарис on 16 Sep 2020 08:07:27

Sometimes its convinient to initalize single selection dropdown slicer with default value based on current dataset or current time. For examle, one may have a slicer setup to track year (..., 2018, 2019, 2020) and it is desired to have a selection in this filter on current year (from DAX NOW() function) upon report open.