Slicer issues

[Anonymous]

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

[Anonymous]

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 · Accepted solution]

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]

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