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
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi AliceW,

the user just has a tremendous advantage to have two slicers, in order to compare product counterparts of different categories in one visual. Referring to the screenshot, the selection could be Slicer 1: Product A & Slicer 2: Product F:

Applying a page level filter on dublicated slicers with "Product" from "Aggregated Table" does not allow a selection in both slicers, because of the connections.

 

An OR condition could be a solution for the two slicers, right?

 

Hope this explaines my problem better.

AliceW's avatar
AliceW
Icon for Power Participant rankPower Participant
5 years ago

In the example you've shown, you can easily select two products with the help of one multi-selection visual...

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi AliceW,

    thanks for your support.

     

    This is an easy possibility and it works.

    However, it would be the objective to have two seperated slicers. One seperate slicer only for products of category A and one for products of category B, both slicing a singe column. Is this possible?

    • AliceW's avatar
      AliceW
      Icon for Power Participant rankPower Participant
      5 years ago

      Info: is having two and only two products in the visual the expected result? And is the list of products reasonably short? If yes to both, you could build two one column tables with the product names, then build two measures using SWITCH in the main table, then use those measures in the visual.

      • Tnt's avatar
        Tnt
        Frequent Visitor
        5 years ago

        Hi.. 

        Could you please elaborate on "then build two measures using SWITCH in the main table, then use those measures in the visual"

         

        I am also facing the same need for comparing our and competitor products.

         

        Thanks