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
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

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.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors