Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Filter cascading issue

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 ...
Need Help
V-lianl-msft's avatar
V-lianl-msft
Community Support
6 years ago

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's avatar
Anonymous
Not applicable
6 years ago

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