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

[ronanfenelon]

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 on the shared axis it only filters cultivation by BAU. i wish to filter every activity by BAU as there are only 6 numbers and they are common to every table. this should not be a hard thing to do and i fear i am missing something very simple here.

if anyone could please help me i need this report finished ASAP. 

[v-lid-msft]

Hi @ronanfenelon ,

How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?

Best regards,

[v-lid-msft · Accepted solution]

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,

[Anonymous]

Can you share a screenshot of your relationship view? My only thought is that there are inactive relationships or no relationship between the tables.