Forum Discussion

powerbiuser9999's avatar
powerbiuser9999
Helper I
4 years ago

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, a...
Need Help
parry2k's avatar
parry2k
Super User
4 years ago

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.

 

 

  • powerbiuser9999's avatar
    powerbiuser9999
    Helper I
    4 years ago

    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?