Forum Discussion
Join two table in une slicer
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
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
2 Replies
freginierSolution Sage
Try to use calendar table connect it to 2 tables and then create slicer on calendar table it will be filter all tables
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