cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sadya
Frequent Visitor

Date Slider as per Project Start Date

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. 

sadya_0-1612115403439.png

sadya_1-1612115483913.png

 

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

5 REPLIES 5
V-lianl-msft
Microsoft
Microsoft

Hi @sadya ,

 

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

V-lianl-msft_0-1612338382888.png

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.

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

 

lbendlin
Super User III
Super User III

" 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.

lbendlin
Super User III
Super User III

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

sadya
Frequent Visitor

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. 

Helpful resources

Announcements
User Groups Public Preview

Join us for our User Group Public Preview!

Power BI User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors