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 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. 

 

 

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,

     

3 Replies

  • v-lid-msft's avatar
    v-lid-msft
    Community 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,

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

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

  • v-lid-msft's avatar
    v-lid-msft
    Community Support
    6 years ago

    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,