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,
Is it possible to create some kind relationship between 2 slicers?
Just a simple example. I have 2 slicers. One slicer includes months and the other one includes seasons. If I select January in first slicer, Winter is automatically selected in the other slicer. I need this because I have to assign these slicers to multiple charts and instead of making 2 clicks in 2 slicers I would like to have just only one slicer.
Br,
Edgars
Solved! Go to Solution.
Hi @Anonymous
Create dimension table like that
MonthID | Month | Season |
1 | January | Winter |
2 | February | Winter |
3 | March | Spring |
4 | April | Spring |
5 | May | Spring |
6 | June | Summer |
7 | July | Summer |
8 | August | Summer |
9 | September | Autumn |
10 | October | Autumn |
11 | November | Autumn |
12 | December | Winter |
Then you should join your dimension table to your transactional data. Create a new column in your transactional data with MonthNo (Dax code should be something like that "date.MonthNo").Then you should join this column with dimension table on ID column. Cross filter direction sholud be both. Finally you should use month and season columns in dimension table.
Hi @Anonymous
Create dimension table like that
MonthID | Month | Season |
1 | January | Winter |
2 | February | Winter |
3 | March | Spring |
4 | April | Spring |
5 | May | Spring |
6 | June | Summer |
7 | July | Summer |
8 | August | Summer |
9 | September | Autumn |
10 | October | Autumn |
11 | November | Autumn |
12 | December | Winter |
Then you should join your dimension table to your transactional data. Create a new column in your transactional data with MonthNo (Dax code should be something like that "date.MonthNo").Then you should join this column with dimension table on ID column. Cross filter direction sholud be both. Finally you should use month and season columns in dimension table.
Hi @Anonymous
This worked! Thank you! 🙂
Br,
Edgars
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |