Reply
PPStar
Helper V
Helper V
Partially syndicated - Outbound

choose date range for a Date Table.

Hello. 

I have a date table coming in from SQL. I ingest this Date table into my semantic Model.  The date table is quite big, as the date starts in 2015 and ends in 2030 (With lots of columns)

 

I want users to connect to this date table in Power BI Desktop - so they connect to the semantic model via a Live Connection. 

Optionally, if they want to add thier own data sources, they can create a composite model. 

 

Is there a way i can create a function in my Power BI Desktop which lets them choose a date range, so they only download data between a specified date range, e.g. 2023 to 2024

 

Note, they are connected to the data table via a Live Connection - so the question is, can they create a function to only a Live Connection / Direct query to limit the date range within a custom range. 

 

Alternativly, is there a better way to acheive this?. 

 

The aim is that the date table is managed by corporate IT that can be re-used by multiple team members. (so one team might need data from 2019 to 2020, other teams might want data from 2020-2023 etc). 

 Users can connect to to the date table, but shouldnt be able to make any changes to it. (Except the ability to limit the date range). 

 

I know if the date table was imported, we can create a filter. Can this be acheived via a function, if so how?

 

Thanks in advance. 

1 ACCEPTED SOLUTION
v-jiewu-msft
Community Support
Community Support

Syndicated - Outbound

Hi @PPStar ,

If I understand correctly, the issue is that you want to limit the date range within a custom range. Please try the following methods and check if they can solve your problem:

1.Go to the report, select the slicer visual.

vjiewumsft_0-1705383655365.png

2.Drag the date field from the date table into the Field area of the slicer.

vjiewumsft_1-1705383687585.png

 

 

 

Looking forward to your reply.

Best Regards,

Wisdom Wu

 

 

 

 

 

View solution in original post

4 REPLIES 4
v-jiewu-msft
Community Support
Community Support

Syndicated - Outbound

Hi @PPStar ,

If I understand correctly, the issue is that you want to limit the date range within a custom range. Please try the following methods and check if they can solve your problem:

1.Go to the report, select the slicer visual.

vjiewumsft_0-1705383655365.png

2.Drag the date field from the date table into the Field area of the slicer.

vjiewumsft_1-1705383687585.png

 

 

 

Looking forward to your reply.

Best Regards,

Wisdom Wu

 

 

 

 

 

ppm1
Solution Sage
Solution Sage

Syndicated - Outbound

This sounds like a great use for a Dataflow. Date tables and org hierarchy data are usually the first two dataflows a company needs.

 

Pat

Microsoft Employee
Idrissshatila
Super User
Super User

Syndicated - Outbound

Hello @PPStar ,

 

they can filter the date table in power query to show date between a certain range that they pick.

 

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Syndicated - Outbound

They are connected to the data table via a Live Connection / Direct Query - They do not have access to Power Query to perform the filter?

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)