Filter cascading issue

[Anonymous]

Hi All,

I am using power bi with SAP BW datasource direct connection. When I am applying filter on slicer it filters chart and table data but not the other slicer data. EX: we  have 2 slicer one is showing country and other is there restecpting cities  and I choose India on first slicer and then want that second slicer should update all it's city automatically but it's not happening.

Anyone please help me to cascading the two slicers.

[V-lianl-msft]

Hi @Anonymous ,

Are these two fields in different tables? What is the relationship between the two tables?

Please check whether the filtering relationship between tables is correct and check that the "edit interaction" between the two slicers is turned off.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @V-lianl-msft ,

I am using direct connection from SAP BW so I am not able to add more than one query, but in power BI each dimention in coming as seperate table by default and as this is direct query all the table maping options is disabled by default.

In slicer I am not able to find and intrection option please help on this

Regards,

Ankita

[V-lianl-msft]

Hi @Anonymous ,

You can refer to this document.

https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions 

If the problem persists,you can consider creating a similar measure and applying it to the visual level filter of the "restecpting cities slicer".

Measure = IF(HASONEVALUE(DimGeography[CountryRegionCode])&&MAX(DimSalesTerritory[SalesTerritoryCountry])=SELECTEDVALUE(DimGeography[CountryRegionCode]),1)

You can also ask for help from SAP data source manager to understand the structure of the table.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @V-lianl-msft ,

These document are good but not resolving my issue. I put country and cities example just to make understand the issue.

I have to apply filter on Approved month, CR status, CR type, Region, and team member. 

Is it possible to have a screen sharing session?

Regards,

Ankita