Forum Discussion
Independent Date Filter
Anonymous see attached, I hope this is what you are looking for, you can use date slicer to see the numbers.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos 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.⚡
Hiparry2k ,
I did try using the userelationship in a measure, but it didn't work. This variable is used in a visual to count tasks. The independent date slider is formatted as a date between filter, but when I slide it, it doesn't produce any results.
This is the formula I used. I tried relating it to one date, which didn't work, and then tried relating it to all dates, which also didn't work.
Thank you!
Anonymous you will create 3 different measures, for create, due, and completion date, and in each measure you will use userelationship function and these use these 3 measures to visualize the data. I hope it makes sense.
parry2k Three different measures for the same variable? I'm not quite following.
Anonymous yes 3 different measure, one for each stage. Maybe it will be easier if you paste sample data and expected output. Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490parry2k Thanks for the guidance.
The expected output is for any tasks that are created, started, or completed within a specific time period should appear in the visualizations based on the parameters in the independent date filter.