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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

Apply the result of 2 different slicers to a table

Hello comunity,

 

I'm having trouble trying to display the result of two different slicers in one table. Basically what I'm having is the following:

 

The tables are something like this

AlejandroCortes_0-1675455468813.png

With the Trading1 and Trading2 tables, individual reports need to be produced and those are working perfectly right now. The reason they are crossed between Company1 and Company2 is because I need to filter the second company through the first one and viceversa. Now, with the summary table, I would like the selection on Company1 and the one on Company2 to be the filter for that one table. Something like this:

If all countries are selected in both slicers, I'll see this:

AlejandroCortes_1-1675456055360.png

But if I filter them, I'll see this:

AlejandroCortes_2-1675456083379.png

But then, in the summary table, I'd like to see smething like this by using the same slicers from before, not other ones:

AlejandroCortes_3-1675456171272.png

I hope I'm making sense.

 

Is this possible? Can someone help me?

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Basically, what was needed was to have the appended table disconnected from the others, and have a measure created for the filtering in this table. The measure uses a SELECTEDVALUE conditioned by the 2 other slicers and works a treat!

View solution in original post

3 REPLIES 3
Ashish_Mathur
Super User
Super User

Hi,

My preferred approach would be:

  1. Append the Trading tables.  Before doing so, you may insert a column in each table with the title of Type.  The Type column should have Trading1 and Trading2 as entries.  This is just so that you can differentiate rows by Trading type
  2. Create a table each for Company and Country
  3. Create a relationship (Many to One and Single) from Company in Trading Table to Company in the Company table
  4. Create a relationship (Many to One and Single) from Country in Trading Table to Country in the Company table

Hope this helps.

  1.  

Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Anonymous
Not applicable

Basically, what was needed was to have the appended table disconnected from the others, and have a measure created for the filtering in this table. The measure uses a SELECTEDVALUE conditioned by the 2 other slicers and works a treat!

Anonymous
Not applicable

Hello @Ashish_Mathur . Your solution works for my table, but then I'd need to select the two countries from one single slicer. Right? My main requirement is that the slicers for the first table both work to select those 2 countries for the second table (the one that would be appended). So, basically, if I select Italy in slicer 1 and then France in slicer 2, those are the two countries I'll see in the second table. Am I making sense?

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.