Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Two slicers for one column

Hi guys,   I am quite new to PowerBI. I would like to have two slicers with products of different categories, which filter one column of a connected table with all product information of both categ...
Need Help
AliceW's avatar
AliceW
Icon for Power Participant rankPower Participant
5 years ago

Tnt, how does your data mode look like? Do you have two tables, one for your company's products and another for your competitors'? How do you connect the products?

Tnt's avatar
Tnt
Frequent Visitor
5 years ago

Hi Alice, 

I have not found a good solution yet. 

 

I have 2 Dimension tables,

1. company's product (along with competitor prodcut; 2 column as shown in first table earlier)

2. competitor product (only one column - competitor product).

 

To have two interactive slicers, first slicer (1) is on my product (Table 1) and it is related to table 2 by bidierctional many to one relation. The second slicer (2) is on Table 2, which is filtered by slicer. 

The two tables (1 and 2) are expected to be fact table.

 

Thanks and regads.

Tinto