Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
shrikant23
New Member

Bidirectional cross filtering not working

Hello Team, 

I have configured bidirectional cross filtering in power bi and pusblish the dataset to premium workspace. While browing it in power bi reports or using desktop  - bidirectional filter is working as designed however it does not work if same model is analyzed in excel.  Filter context does not work in excel - it performs cross join between site organization and site table. 

am I missing anything or this is bug on excel side due to way it forms the query in MDX? 

 

shrikant23_0-1648689961369.png

 

3 REPLIES 3
shrikant23
New Member

I have configured the log analytics for power bi workspace to capture DAX and MDX queries generated for this issue.  My conclusion is - this is analyze excel issue not having ability to pass filter context. 

 

 

shrikant23_0-1648729718831.png

 

shrikant23
New Member

As you see - power bi report do pass filter context from site org to site and other way while same model analyzed in excel is performing cross join by mapping all sub departments from site with filtered dept from site org 

 

shrikant23_0-1648725974108.png

 

amitchandak
Super User
Super User

@shrikant23 , Can share screenshot of what is not working

 

 

I do not see any limitation mentioned here

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-analyze-in-excel

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.