Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello Powerbi Developers,
I am having one requirement.
I am having date column in which data is for whole year, but we want to show dynamically with help of Today() -1 function.
eg today is 11/10/22 i want to show data in dashboard till 10/10/22.
So how can we implement it.
Please help me out here on above issues/blockers.
Regards,
Solved! Go to Solution.
@Anonymous , You need to apply measure as visual level filter. Please refer the attached PBIX.
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Hi @Anonymous ,
Please write the measure like below and place it in the visual level filter of the slicer
Hi @Anonymous ,
You can create a measure as below and use it as filter on the visuals you want to apply this filter.
Measure =
IF ( MAX ( 'Table'[Date] ) <= TODAY () - 1, 1, 0 )
Thanks,
Samarth
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Not Working !!
@Anonymous ,could you please show how you have implemented? or if you could share your PBIX after removing sesitive data?
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
I have this same question - I have a date table that has dates until the end of the year 2023, but I only want my slicer to show dates up until yesterday.
I tried this measure but it doesn't accept it?
@Anonymous , You need to apply measure as visual level filter. Please refer the attached PBIX.
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Ah, that works. Thank you!
One final thing, if I may.... I have two tables that each have their own date (in the same format). Is there a way to make one slicer do a filter on dates and pull back the necessary statistics?
I can share my pbix file if that makes it easier
@Anonymous You could create a date table and join your tables to it. Then use date table on slicer.
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
124 | |
79 | |
49 | |
38 | |
37 |
User | Count |
---|---|
196 | |
80 | |
70 | |
51 | |
42 |