Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
powerbisupcl
New Member

How to add today to a date slicer

Hello,

 

I would like to add today to a date slicer for the between slicer setting. I have a set day say 1/1/2023 and set the last date to be today instead of static date selection.

Is that possible to do in power BI? for example in the picture below instead of 2/28/2024, the selection would be today.

 

powerbisupcl_0-1674060028941.png

 

1 ACCEPTED SOLUTION
Seanan
Solution Supplier
Solution Supplier

Hi @powerbisupcl 


You can create a calculated column with the following code:

Date Range = 
    VAR _Start = [Date]
    VAR _End = TODAY()
    RETURN [Date] >= _Start && [Date] <= _End

Then add this column as a filter on the visual and set the filter to True

Super User Signature.PNG

View solution in original post

2 REPLIES 2
Nayan_surya
Frequent Visitor

Hi @powerbisupcl ,

 

Have you tried using any custom visual for Date slicing? because belive me they are life savers when it comes about functionality and features.

I am talking about custom visual named Date Picker by Powerviz. Not just Today, it provides a lot of presets which are really useful with little to no need to write dax that too with custom / in built themes.

 

Nayan_surya_0-1702626626441.png

 

I think you should check them out.

Here is a link if you want to check this visual - https://appsource.microsoft.com/en-us/product/powerbivisuals/truvizinc1674781244292.date-picker-by-p...  (I believe they offer a free version too)

 

Seanan
Solution Supplier
Solution Supplier

Hi @powerbisupcl 


You can create a calculated column with the following code:

Date Range = 
    VAR _Start = [Date]
    VAR _End = TODAY()
    RETURN [Date] >= _Start && [Date] <= _End

Then add this column as a filter on the visual and set the filter to True

Super User Signature.PNG

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.