Data Modelling Cohort Filters

[esingh]

Hi All,

I am working on power BI and we have to create a filters in the following format:

The catch being I dont want to select the selected institute (Carnegie Mellon) again in the cohort for it to get plotted on the visualization( Scatter Plots) . Is there a way to achieve this. If anything else is needed please let me know

Thanks 

[mark_endicott]

@esingh - Without more detail on your model, and the relationship between the College Name and Cohort columns it's tricky to suggest a solution that would work. 

However one thing you could look at is a hierarchical slicer involving both fields see here for more details: https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-slicer-hierarchy-multiple-fields 

If this helps, please accept as the solution to assist others with the same challenge.