Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
colettb
Helper I
Helper I

Filter Choice Controlling Other Filters

Hello Community!

 

I am developing a dashboard and have multiple filters.  What I am wanting to do is when the user makes a choice with one filter, the other filters will have their options modified.  

 

As an example, let's say I have 2 filters - Phase and Study.  The Phase filter has 3 choices - Early Phase, Ongoing and Post Market.  The Study filter has a list of clinical studies.

 

If the user chooses all options in teh Phase filter, all clinical studies will be listed in the Study filter.  What I want is that if the user chooses, for example, Early Phase in the Phase filter, I want only Early Phase studies to be listed in the Study filter.  

 

So basically I want the values chosen in one filter to control what is available to choose from in other filters.  

 

Thanks for any guidance you can give me!

1 ACCEPTED SOLUTION
mh2587
Super User
Super User

1. Ensure Proper Data Model Design
You need a structure where both Phase and Study belong to the same table, or they are properly related.
Alternatively, if you have dimension tables:
PhaseDim (PhaseID, PhaseName)
StudyDim (StudyID, StudyName, PhaseID)
Then ensure:
StudyDim[PhaseID] is related to PhaseDim[PhaseID]
Your fact table has StudyID, which connects to StudyDim[StudyID]

2. Add Slicers
Add a slicer for Phase
Add another slicer for Study
Power BI will automatically filter the Study slicer based on the selected Phase if the model relationships are correct.

3. Ensure Relationships Are Set to "Single" Direction
Go to Model View and ensure:
Relationships between Phase → Study are set to Single directional filtering (from Phase to Study or from Study to Fact).
Avoid bidirectional relationships unless absolutely needed.

4. Avoid Adding Filters from Unrelated Tables
If your slicers come from unrelated tables, cascading will not work. Make sure the filter field sources are properly related either directly or through a fact table.


Did I answer your question? If so, please mark my post as a solution!


Proud to be a Super User!




LinkedIn Icon
Muhammad Hasnain



View solution in original post

5 REPLIES 5
colettb
Helper I
Helper I

Thank you everyone for your great suggestions!  I was able to resolve my issue.  

grazitti_sapna
Super User
Super User

Hi @colettb 

1. Ensure Proper Data ModelYou need to ensure that your data model contains both the tables are logically connected.
2. Create a relationship between Phase and Study (You can set cross filter direction between both the tables).

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!


v-kpoloju-msft
Community Support
Community Support

Hi @colettb,
Thank you for reaching out to the Microsoft fabric community forum. Thank you @Jai-Rathinavel@mh2587, for your inputs on this issue.

After thoroughly reviewing the details you provided, I reproduced the scenario again, and it worked on my end. I used it as sample data and successfully implemented it.

outcome:

vkpolojumsft_0-1748501483966.png


I am also including .pbix file for your better understanding, please have a look into it:

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you for using Microsoft Community Forum.

Jai-Rathinavel
Super User
Super User

Hi @colettb  Since I don't have Visibility to your data model layout I would suggest a simple fix.

 

Select your Relationship in Data Model View and Set the Cross Filter Direction to Both bewteen the tables.

 

JaiRathinavel_0-1748450647473.png

 

Thanks,

Jai Rathinavel | LinkedIn




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





mh2587
Super User
Super User

1. Ensure Proper Data Model Design
You need a structure where both Phase and Study belong to the same table, or they are properly related.
Alternatively, if you have dimension tables:
PhaseDim (PhaseID, PhaseName)
StudyDim (StudyID, StudyName, PhaseID)
Then ensure:
StudyDim[PhaseID] is related to PhaseDim[PhaseID]
Your fact table has StudyID, which connects to StudyDim[StudyID]

2. Add Slicers
Add a slicer for Phase
Add another slicer for Study
Power BI will automatically filter the Study slicer based on the selected Phase if the model relationships are correct.

3. Ensure Relationships Are Set to "Single" Direction
Go to Model View and ensure:
Relationships between Phase → Study are set to Single directional filtering (from Phase to Study or from Study to Fact).
Avoid bidirectional relationships unless absolutely needed.

4. Avoid Adding Filters from Unrelated Tables
If your slicers come from unrelated tables, cascading will not work. Make sure the filter field sources are properly related either directly or through a fact table.


Did I answer your question? If so, please mark my post as a solution!


Proud to be a Super User!




LinkedIn Icon
Muhammad Hasnain



Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.