Join two table in une slicer

[alvino]

Ola Boa Tarde

Tenho duas colunas de data.

Numa unica linha possui 2 meses diferentes, gostaria de  selecionar num unico slicer o mes de Novembro, ele apanha-se o mes de Novembro nas duas colunas

[Anonymous · Accepted solution]

HI @alvino,

You can create a bridge table with unique values to link these two tables, then the filter effects can be filtered on two tables based on the bridge table relationship:

How to Join Many to Many with a Bridge Table in Power BI | Seer Interactive
Regards,

Xiaoxin Sheng

[freginier]

Try to use calendar table connect it to 2 tables and then create slicer on calendar table it will be filter all tables