topic Re: Date Slider as per Project Start Date in Developer

Date Slider as per Project Start Date

Anonymous — Sun, 31 Jan 2021 17:54:44 GMT

Thank you for the forum. I have a question.
I have 2 tables. One is the date table and the second table is the project table. In project table (ID, project name, start date, end date).
The relationship is one -many (Bi-directional), From date table to project table.

When the user selects any project from the project selection slicer then automatically date slicer will set as per the project start date.

Please! can someone help me with this query. Thank you

Re: Date Slider as per Project Start Date

lbendlin — Mon, 01 Feb 2021 01:15:31 GMT

Please explain the reasoning for making the search filter bidirectional. What is the actual business problem that you are trying to solve?

Re: Date Slider as per Project Start Date

Anonymous — Mon, 01 Feb 2021 03:44:39 GMT

Thank you Ibendlin.

Actually, we have more than 26 projects that are ongoing and our clients monitor the project activities through the dashboard. That's why they have requested to set the date slider as per the project start date. I have displayed the project start date in Card visual however clients are not satisfied.

Appreciate the assistance.

Re: Date Slider as per Project Start Date

lbendlin — Mon, 01 Feb 2021 03:48:12 GMT

" That's why they have requested to set the date slider as per the project start date"

Tell them that's not how Power BI works. Your Card visual option (or a text box) is a better choice.

Re: Date Slider as per Project Start Date

V-lianl-msft — Wed, 03 Feb 2021 07:56:01 GMT

Hi @Anonymous ,

Maintain both filtering relationship and open editing interaction, so that the two slicers interact with each other.

But this only shows the date of the corresponding line, which is the single start date..

According to my attempt, the range of slicer cannot be changed dynamically based on another related table slicer.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Date Slider as per Project Start Date

Anonymous — Wed, 03 Feb 2021 10:22:25 GMT

Thank you for your reply. If I use the Edit interaction option it shows the project start date but disabled the slider. Is there any way to resolve this issue. Please