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.

       

       

       

      • vjnvinod's avatar
        vjnvinod
        Impactful Individual
        8 years ago

        Phil_Seamark Mond

         

        Hi thanks for the suggestion, but doesn't seems to be working, look at my scrubbed pbix file below.

        https://www.dropbox.com/s/kaqbg9fc8h3wpo1/testchecknew.pbix?dl=0

         

        My issues starts while i filter for a specfic value in the region, could be any region and i realised that tables/charts, doesn't interact properly.

         

        However it works with my filter for Account sector.

         

        Do let me know, if there is way i can fix this, i must be doing something incredibly wrong.

         

        thanks for taking time and suggesting any change