Solved: Slicer issues

Anonymous · ‎10-26-2022

Hi,

I'm working on a report using Power BI service and need help on how to use one slicer on 4 different tables. The column used for the slicer is present in all the tables.

Kindly help.

Thank you

v-yadongf-msft · ‎10-27-2022

Hi @Anonymous ,

I created three tables with a common date column.

Please create relationships based on date column between three tables like below shown:

So, the slicer from table1 can filter three tables at the same time.

Please refer the attached pbix file.

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Anonymous · ‎10-27-2022

I'd rather suggest to create dimensional table for all dates from columns by dax

= distinct(

union(

distinct(table1),

distinct(table2)

))

If you connect dates by relationship to dimensional table, you can slice it up by 1 slicer

v-yadongf-msft · ‎10-27-2022

Hi @Anonymous ,

I created three tables with a common date column.

Please create relationships based on date column between three tables like below shown:

So, the slicer from table1 can filter three tables at the same time.

Please refer the attached pbix file.

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yadongf-msft · ‎10-26-2022

Hi @Anonymous ,

Can you explain your problem in details ?

It would be great if you could tell me what's your expected output and share with me some screenshots of your data after hiding sensitive information.

Best regards,

Yadong Fang