Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Slicer issues

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. Tha...
General Comment
Need Help
Show and Tell
Tips and Tricks
  • v-yadongf-msft's avatar
    v-yadongf-msft
    3 years ago

    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.

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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