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
Anonymous
Not applicable

Enable cross-filtering and cross-highlighting in the direct query

Kindly I have a report contains many visuals and slicers. Im using direct queries (more than ten queries) to get the data from SQL and KQL, I want to enable the cross-filtering and cross-highlighting between the visuals which will allow the user to select anything from any visual and the entire report will be filtered based on the selection even the slicers 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @v-jingzhang thank you for your feedback, as work around, what I did is I created a KQL direct query and add (FromDate, ToDate) as a (Parameters) and ( |project)  all the columns then use DAX measures to get the calculations.

 

Really Appriciated ,

 

Regards,

Wael

View solution in original post

6 REPLIES 6
Anonymous
Not applicable

@v-jingzhang thank you for your reply, actually, I did the same, but in my case all the queries are direct queries without any relationship beween the queries and each visual is using different queries so is there any other posibilities ?

Hi @Anonymous 

 

I'm afraid this is not possible when there is no relationship between the tables. The cross filtering and cross highlighting behaviors are intended to show the related values in other visuals when you select a value or axis label in one visual. If there is no relationship existing, they cannot find which values are related, thus they cannot filter or highlight values in other visuals. 

 

Best Regards,

Jing

 

Anonymous
Not applicable

Hi @v-jingzhang thank you for your feedback, as work around, what I did is I created a KQL direct query and add (FromDate, ToDate) as a (Parameters) and ( |project)  all the columns then use DAX measures to get the calculations.

 

Really Appriciated ,

 

Regards,

Wael

Anonymous
Not applicable

so instead of many queires , I have now one query in which the cross-filter and cross-highlight is enabled 

Yes. Columns in one query have invisible relationships between each other, so they are able to be cross-filtered or cross-highlighted when displayed in different visuals. 

v-jingzhang
Community Support
Community Support

Hi @Anonymous 

 

In Power BI Desktop, you can select the option "Change default visual interaction from cross highlighting to cross filtering" from Options > Current File > Report settings. This affects the whole report. 

vjingzhang_0-1688526936702.png

 

If you want to change interactions between some specific visuals, you can select a visual to make it active, then select Format > Edit interactionsChange how visuals interact in a report - Power BI | Microsoft Learn

vjingzhang_1-1688527279229.png

 

Please notice that some visuals may only support cross-filtering or cross-highlighting. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

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.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

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.