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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
ek2112
Advocate II
Advocate II

Dynamic filtering of a table based on parameter selection

I have a table of tasks as follows: 

table.png

I have three parameters on my pbix file - day, month and year. I am trying to get the above table to display just those rows whose finish date is greater than the user selected date and % complete is 100. Ex: If the user selects through parameters 8/1/2019, the table should filter to show just row 10 as that is the only row as per the criteria (% complete = 100 AND finish date >  user selected date). 

 

Here is the link to the PBIX. I tried the CALCULATETABLE but not successful. Thanks in advance.

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

@ek2112 

 

You may refer to the following post.

https://community.powerbi.com/t5/Desktop/Use-a-date-slicer-to-filter-on-a-period-instead-of-a-single...

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-chuncz-msft
Community Support
Community Support

@ek2112 

 

You may refer to the following post.

https://community.powerbi.com/t5/Desktop/Use-a-date-slicer-to-filter-on-a-period-instead-of-a-single...

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@v-chuncz-msft  thanks for pointing me in the right direction. This gave me ideas suitable for my situation.  

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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