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.⚡
Anonymous if you have used these measures in your visual, and assuming you have used userelationship function in your measures to make an inactive relationship to active, all measure values will be shown based on the selected date range, and it should work. Please provide more context with example/screenshots if this doesn't answer.
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/38490