Forum Discussion
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.
Thank you
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.
3 Replies
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
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.