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

[Anonymous]

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 

[Anonymous]

@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 ?

[v-jingzhang]

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 · Accepted solution]

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]

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

[v-jingzhang]

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]

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. 

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

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.