Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
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.
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
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.
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
60 | |
57 |
User | Count |
---|---|
188 | |
111 | |
105 | |
78 | |
71 |