2 synced/dynamic slicers

[Anonymous]

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

[Anonymous · Accepted 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.

[Anonymous]

Hi @Anonymous 

This worked! Thank you! 🙂

Br,

Edgars