Forum Discussion
Values displaying based on date selection
Hi
I have a specific use case which I am little unsure about.
I have a database table where various legal cases have a start date and an end date.
My customer would like to select 2 dates, and on that selection, a table visual to be populated with all the cases that were open at any point during the selected dates.
So, for example, if the customer selected 1st Dec - 31st Dec, any case that was open at any point during that period would be displayed in the table visual.
A case that was started on the 1st November and ended on the 15th December would be included in the visual.
A case that was started on the 29th December and has yet to end (End Date blank) would be included in the visual.
A case that was started on the 1st November and ended on the 19th November would not be included in the visual.
I hope thats clear, but if anyone could guide me that would be appreciated.
5 Replies
powerbiuser9999 similar solution posted a few weeks ago, see attached, tweak it as you see fit.
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.
Hi parry2k
Thank you for replying. In your file I couldn't see any relationship between the two tables, so I am unsure how this is functioning. This also works on a monthly slicer, and despite changing settings to days, I am unable to make it replicate the results.
Do you have any further pointers?
powerbiuser9999 hmmm the technique is going to be the same, maybe share your pbix file and I can take a look.
parry2k Hey, sorry for the delay.
I asked my boss and they've aid I'm not allowed as it is confidential I'm afraid.
It is really bugging me as your example seems identical to mine, but it delivers different results!
powerbiuser9999 you can always create dummy data and share that. I don't how else to provide a solution.
✨ 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.
