How to set Today's Date By default in Page Filter in Power BI Desktop

[VijayAntonyM]

HI Team,

Good Day,

We need support on below issue,

As need to set and select the today's date by default in the Page Filter, User can even select other dates also.

Also date filter should be basic filter type, By default it should select the today's date in the page filter.

Kindly help us on this.

Regards

M. Vijay Antony

[shafiz_p]

Hi @VijayAntonyM  As you want that your filter type on "Page Filter" should be "Basic Filter" and by default today's date will be selected and will change every day as well as you would be able to change other dates too.

For your kind information, Such scenario in page filter is not possible to implement. Selection is constant. If you want only today's date or any selection, that is possible. Use Today() function. For this you need to create a calculated column to identify todays date. If today then code Today, else Otherday or anything you want. Place the column in page filter, select basic filtering, then check only Today and uncheck Otherday. Your page will be filter accordingly everyday. But you won't be able to select other day unless you change.

You can use relative filter too, in this case, you can go with the solution provided by @Idrissshatila and  @Ankur04.

For successfully and easily impliment both the scenario, slicer is a good option. In this way you will be able to filter page automatically by todays date as well as will have the ability to check other dates too. If you want, you can check my earlier solution. 

Auto Select Todays Date in Slicer as well as change date manually 

Just need to tweek the custom column formula for today. Here is :
= if [Date]=Date.From(DateTime.LocalNow()) then "Today" else [Date]

Hope this helps!!
If this solved your problem, please accept it as a solution!!

Best Regards,
Shahariar Hafiz

[Ankur04]

Hi, 

you can try below setting on page filter pane.

let me know if you need more details.

Thanks,

[Idrissshatila]

Hello @VijayAntonyM ,

apply the following

[VijayAntonyM]

Hi,

We should not use Relative date filter, User is looking for all the dates should be displayed in basic filter type.

only the today's date needs to be selected and other dates are deselcted.

Kindly help

regards

M. Vijay Antony

[Anonymous]

Hi @VijayAntonyM ,

As others have cautioned, the choice in BASIC FILTER TYPE is constant.

Another workaround is provided here to customize the visual using a pre-selected slicer. By configuring it you can automatically select today's date.

Users can also manually select other dates.

Preselected Slicer

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[Idrissshatila · Accepted solution]

Hello @VijayAntonyM ,

I made a video to walk you through the process of acheiving your request
https://youtu.be/kVcStgZhnuw