Forum Discussion

Anchit_Thomas's avatar
Anchit_Thomas
Icon for Helper I rankHelper I
5 years ago
Solved

How to pass filters to different backend SQL tables

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 "bra...
Need Help
  • Icey's avatar
    Icey
    5 years ago

    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.