Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Rck7
Helper II
Helper II

How do I edit interactions between two slicers with fields from a smiliar table?

Hello friends,
I am fairley new to Power BI and looking for your help on an issue that I am facing while trying to work with the slicers.

Goal - I have an Employee table and a Ticket table, where I am trying to display the Ticket Descriptions of the employees(in a table) who careated the ticket  from different office locations. 

Data- On the Employee table, I have a Location column with International, Domestic office names listed for each record.

Issue - I have created two slicers  with the location field trying to limit the selections, having Internationl offices to display on one slicer and domestic offices on the other. I am facing an Issue where I am unable to control interactions resulting in displaying the same selections on both the slicers. How would I be able to resolve it?

Here is a glimpse of what I am doing:

8-20-2018 4-07-12 PM.png

Any help would be very much appreciated!!

Thank you. 
 

2 REPLIES 2
v-lili6-msft
Community Support
Community Support

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

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

@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. 


  

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.