Forum Discussion

vjnvinod's avatar
vjnvinod
Impactful Individual
8 years ago

relationship setup

Hi,   how to easily setup the interaction between all of the visuals and charts. for instance i have 2 tables (Inbound and outbound) contains the same information.   I had to split this to 2 tabl...
Need Help
Show and Tell
Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

isualsHi vjnvinod

 

One thing to make sure you do is to use the HQRegion field from the Region table in your slicers and also on the axis of your visuals.  Go so far as to hide the HQRegion fields in both the Inbound and Outbound table.

 

That way, when a filter is being applied using the 'Region[HQRegion] field, it gets applied to rows in both Inbound and Outbound.

  • vjnvinod's avatar
    vjnvinod
    Impactful Individual
    8 years ago

    Phil_Seamark

     

    I have used the below DAX for creating a newtable as region

    Region =
    FILTER(
    DISTINCT(
    UNION(
    DISTINCT(Inbound[HQRegion]),
    DISTINCT(Inbound[DeliveryRegion])
    )
    ),
    NOT(ISBLANK(Inbound[HQRegion])))

     

     

    Go so far as to hide the HQRegion fields in both the Inbound and Outbound table? Not sure why i have to hide this?

    • Phil_Seamark's avatar
      Phil_Seamark
      Microsoft Employee
      8 years ago

      Hi vjnvinod

       

      I only suggested you hide those fields so you don't accidentally use them in your slicer, or on an axis. 

       

       

      • Phil_Seamark's avatar
        Phil_Seamark
        Microsoft Employee
        8 years ago

        Just to be clear.  Only use fields from the middle tables (surrounded by the red rectangle) for your slicers and on the axis of your visuals.

         

        Do not use ANY fields from the two tables with the red crosses in a slicer or on the axis of a visual.  You can use numeric fields from these tables for measures etc.