Forum Discussion
How do I edit interactions between two slicers with fields from a smiliar table?
Hi@ Rck7
According your description and the picture ,column International office and column Domestic office should be in the same table ,
So they will Interact with each other.
If possible, please share detail steps for us to reproduce the issue.
You can share some data sample and the formula and expected output or pbix file. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.
Best Regards,
Lin
v-lili6-msft Thank you for the reply. As mentioned, I just have a location column which has both international and domestic offices listed.
Additionally, I created a conditional table with column Employee ID(Copied from the employee table) and a calculated column to list the Internationl offices(from the employee table).
Now, I have two slicers- 1)Domestic Offices 2) International Offices and a Table representing all the data for the selected slicers.
I am trying to hide the international offices from the Domestic office slicer and represent the international offices just in the other one.
When ever I try to de-select the international offices from my page level filter(locations), it is getting de-selected in the other slicer too. Kindly,share your thoughts on it.
Thank you.