Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Use same filter value for to separated tables

Hi there,

 

I am trying to create an interactive dashboard that will show 2 visuals once the user selected the desired filter.

 

Let's say I have the following two files loaded into PowerBi Desktop:

 

COUNTRYGENDERTOTAL COSTUMERS
USAM45
USAF65
UKM67
UKF86
FINLANDM23
FINLANDF21
SPAINM13
SPAINF15

 

and

 

COUNTRYAGE BANDTOTAL COSTUMERS
USAChild56
USAAdult75
UKChild34
UKAdult98
FINLANDChild23
FINLANDAdult45
SPAINChild65
SPAINAdult23

 

I am trying to create 2 visuals (one for GENDER and one for AGE BAND) and I would like to create a unique filter for COUNTRY so that once the user selects USA only, the 2 visuals updates automatically.

 

Unfortunately, I need to put both filters in the "Filters on this page" section to control both visuals, whereas I would like just to have one since the values in COUNTRY are the same, but due to the duplicates, I can't join.

 

Thanks

 

Simone

Need Help
  • johnt75's avatar
    johnt75
    4 years ago

    Create a separate Country dimension table using

    Country = DISTINCT( UNION(
   VALUES('Table1'[Country],
   VALUES('Table2'[Country]
))

    create relationships from the new table to both existing tables and then place your filter on the new table.

1 Reply

  • johnt75's avatar
    johnt75
    Super User
    4 years ago

    Create a separate Country dimension table using

    Country = DISTINCT( UNION(
   VALUES('Table1'[Country],
   VALUES('Table2'[Country]
))

    create relationships from the new table to both existing tables and then place your filter on the new table.