Slicer from Different Tables (Need to filter without Bidirectional Relationship)

[Prarabdha_07]

Hello PBI Experts,

I have two Tables connected through ID Column

Attaching Screenshot --

I have two slicers in my Page

1. City

2. Name

As per the direction city slicer will not filter the Name Slicer and i don't want bidirectional Relationship so i use the Visual level filter under Name (where Sales is not Blank) and not it is working but when i remove the selected value from first slicer, all values are not coming in the other slicer. (Only A and S are coming in Name Slicer.

Can we achieve this without BI-directional Relationship?

[wini_R · Accepted solution]

Hi @Prarabdha_07,

Try to modify your visual level filter measure to:

filterSlicer = 
IF(
    ISFILTERED(Many[City]), 
    INT(NOT ISEMPTY(Many)),
    1
)

[Prarabdha_07]

thanks @wini_R for your help, it is working