Automate Power BI Date Slicer to Current Date by Default.
Many of us have encountered this problem where we want the date to change automatically to the current date but we are unable to do so in power bi slicer. In this post We are going to discuss some steps to overcome this issue.
The first one is “Chiclet slicer” visual which can be found in https://app.powerbi.com/visuals/ . This visual gives us a feature to force select any value in the slicer.
To implement this, go to format and select General there you will find force select option. Click on desired value and use force select option to select date by default. With this option the desired value will be selected until it is undone.
To set the date to today by default use the following DAX formula and create a calculated column.
Current date = IF((Date table[Date] = TODAY()),”Today “ , Date Table[Date]&””)
Use the calculated column in “Chiclet slicer”, sort the visual in descending order. You will see a text ‘today’ click on today and use force select option in format pane. In this way you can use Chiclet slicer to get dynamic date.