Forum Discussion

ronanfenelon's avatar
ronanfenelon
New Member
6 years ago
Solved

Help Needed; How To: Multiple tables sharing the same field on the shared axis to filter table

I have 4 tables which i ahave linked to the same column chart. Each table 4records a certain action taking place. the x axis filters by BAU (Location). When i have BAU from the cultivation activity o...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi ronanfenelon ,

     

    We can create a calculated table and use it as the Shared axis after create relationship with other four tables:

     

    BAU_Table =
DISTINCT (
    UNION (
        DISTINCT ( 'Cultivation'[BAU] ),
        DISTINCT ( 'Health_Safety'[BAU_no] ),
        DISTINCT ( 'Maintenance'[BAU_no] ),
        DISTINCT ( 'Planting_FillingIn'[BAU_no] )
    )
)


    Best regards,

     

v-lid-msft's avatar
v-lid-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi ronanfenelon ,

 

We can create a calculated table and use it as the Shared axis after create relationship with other four tables:

 

BAU_Table =
DISTINCT (
    UNION (
        DISTINCT ( 'Cultivation'[BAU] ),
        DISTINCT ( 'Health_Safety'[BAU_no] ),
        DISTINCT ( 'Maintenance'[BAU_no] ),
        DISTINCT ( 'Planting_FillingIn'[BAU_no] )
    )
)


Best regards,