Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
COUNTRY | GENDER | TOTAL COSTUMERS |
USA | M | 45 |
USA | F | 65 |
UK | M | 67 |
UK | F | 86 |
FINLAND | M | 23 |
FINLAND | F | 21 |
SPAIN | M | 13 |
SPAIN | F | 15 |
and
COUNTRY | AGE BAND | TOTAL COSTUMERS |
USA | Child | 56 |
USA | Adult | 75 |
UK | Child | 34 |
UK | Adult | 98 |
FINLAND | Child | 23 |
FINLAND | Adult | 45 |
SPAIN | Child | 65 |
SPAIN | Adult | 23 |
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
Solved! Go to Solution.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |