Moving 'some' results from one tab to another

[VDO]

Hello Power BI Community,

I have a Power BI report with two tabs: one containing a color selector applied to a furniture table, and the other displaying a table with both furniture and color fields. In my dataset, I have two columns: "Furniture" and "Color," with five records: red chair, green chair, red table, green wardrobe, and blue wardrobe.

In the first tab, the color selector enables users to pick a color. Upon selecting a color (e.g., blue), I want the table to display the corresponding furniture item (e.g., "Blue Wardrobe").

In the second tab, I aim to show all records related to the furniture showed in the first tab. For instance, if the "Blue" color is selected, the table should display both the "Blue Wardrobe" and the "Green Wardrobe."

Could someone guide me on how to achieve this functionality using Power BI? I've attempted to set up slicers and filters, but I'm struggling with the precise implementation.

Thank you in advance for your assistance!

Best regards,

[rubayatyasmin]

@VDO 

sync the slicers between pages and create a relationship between two tables. 

Would be efficient if you provide the pbix file. 

[VDO]

Thanks for your answer!!

If I synchronize the color slicer, in the second tab it would display only one record, the one for Blue Wardrobe, and actually I want to see in the second tab "Blue Wardrobe" and the "Green Wardrobe."

Which two tables should it relate? Actually, I only have one table in the database, with the columns color and furniture.

Should I create two separate tables? If you explain this part to me, I could create a pbix file.

Thank you very much for your help

[rubayatyasmin]

Can you provide a sample dataset? I will reproduce the problem and try to solve it. 

[VDO]

Of course, the case posed would be with a csv like this

"Furniture","Color"
"Chair","Red"
"Chair","Green"
"Table","Red"
"Wardrobe","Green"
"Wardrobe","Blue"

At the data level, the case is straightforward.

Thanks again for your comments and help  🙂🙂🙂

[rubayatyasmin · Accepted solution]

I got this:

Tab1 :

1. create a slicer and a table visual

Tab2:

1. This page should be drill-through page based on the Furniture col

2. turn-off the keep all filters option

and you are good to go. 

You just need to use the drill through to page 2