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
Tnt's avatar
Tnt
Frequent Visitor
5 years ago

Hi Alice,

Thank you for the response. 

 

Plese find the problem details for which I am unable to realize the solution.

 

I have two or our product - AA and BB, which need to be compared individually with Competitor products XX, YY, and ZZ (see table below of possible comparisons)

 

My ProductBenchmark Product
AAXX
AAYY
BBYY
BBZZ

 

I created two Dimension table, one for my product and one for competitor products. The selection on our product (slicer) will refine the options in  competitor products (second slicer).

 

For eg: if i select AA in prodcut the options in second slicer will be XX and YY but not ZZ (as its not benchmarked against).

 

Now I need to select either XX or YY of our competitor product.

 

The selection then needs to identify related data from a fact table as shown below.

ProductTest result
XX8
YY9
ZZ7
AA7
BB8

 

For selection AA in first slicer and XX in second slicer, visualizer (Table/column) should give values for the selection.  (like the table below)

ProductTest result
AA7
XX8

 

Could you help me with this.

 

Thanks for your support.

 

Regards

Tnt

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