Forum Discussion
How can I filter a table visual data on date column based on slicer value?
Hi,
I have a table visual which has Date_Needed column, and a slicer which has numeric values which comes from table which has numeric column Days . I want to filter the data on table visual on below condition
Date_Needed < Today() + SELECTEDVALUE('Table'[Days])
Expected output-
NSC7 use the following measure on visual level filter where value = 1
Date Needed Measure Filter = ( MAX ( Table[Date_Needed] ) < Today() + SELECTEDVALUE('Table'[Days]) ) + 0✨ Follow us on LinkedIn and to our YouTube channel
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.
3 Replies
NSC7 use the following measure on visual level filter where value = 1
Date Needed Measure Filter = ( MAX ( Table[Date_Needed] ) < Today() + SELECTEDVALUE('Table'[Days]) ) + 0✨ Follow us on LinkedIn and to our YouTube channel
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.
NSC7 Awesome 👏
✨ Follow us on LinkedIn and to our YouTube channel
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.
