How to pass filters to different backend SQL tables

[Anchit_Thomas]

Hi Everyone,

I have three visuals in my report, assume a graph and two different tables.

Now data for these thee visuals come from three different SQL tables. There is a filter - slicer say "brand" at the top.

We want this filter (which comes from SQL table of graph) to affect all the three visuals. How can we do this ?

One way is to create relationships between tables but as I am using direct query and size of data in each table is very large I dont want to go with this due to performance issues.

Is there any other way we can achieve this ? 

Thank you in advance.

[Icey · Accepted solution]

Hi @Anchit_Thomas ,

Try to create a measure and put the measure into "Filters on this visual". 

Measure = IF ( MAX ( 'Table'[Column] ) IN VALUES ( 'graph'[Column] ), 1 )

 For example, put the above measure into "Filters on this visual" field of the three visuals and set as "is not blank",

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anchit_Thomas , refer if this feature can help

https://powerbi.microsoft.com/en-us/blog/power-bi-october-2020-feature-summary/#_Toc51665421