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

Need Help

4 Replies

  • V-lianl-msft's avatar
    V-lianl-msft
    Community Support
    6 years ago

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