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

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'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