Power BI One Slicer to filter other slicers

[Gus_968]

Hi,

As shown in below screen shot, I have create a measure called: Mutual Slice Filter and used it to filter Scenario Slicer based on Financial year slice. I have added the measure to Filter Pane in Filter on this visual section. However looks like my solution is not working properly as when I select financial year 2021-22, scenario "FOR" ( Forecast) is not appearing in Scenaro slicer though it exists in financial year 2021-22. To prove that it exists I created a table visual which list all scenarios in 2021-22. Am i missing something?

Thanks 

[PaulDBrown · Accepted solution]

It's hard to see without knowing how your model is set up, which tables are used for the slicers, what each field means....

If you want one slicer to filter another, and the fields used are in dimension tables, create a measure along the lines of:

Filter Slicers = COUNTROWS (RELATEDTABLE(Fact Table))

Add the measure to the filter pane for each slicer and set the value to greater or equals to 1.

If that isn't the problem, please share sample non-confidential data or a link to a PBIX file in a clud service and a depiction of the expected outcome.