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,

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

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

      This is what I do to allow the users to switch the report visuals between currencies.

      1. I created a table (Home / Enter Data) with two values: EUR and USD. You can use as many as you want. Called it 'Currency'. No need to create any relationship with this table.

      2. In the table where you have your amounts, create this measure:

      Total =

      SWITCH(
      TRUE(),
      SELECTEDVALUE('Currency'[Currency])="EUR",sum(Opp[Total EUR]),
      SELECTEDVALUE('Currency'[Currency])="USD", sum(Opp[Total USD]),
      sum(Opp[Total EUR])
      )
      The last sum is just in case you use the measure without the switch...
      3. In the report, you add a Slicer with the 'Currency' column. In its Selection Controls, make sure you have 'Single Select' on.
      4. Build the visual with the new Total Measure.
       
      You can apply this logic to your competitor issue; have two one-column tables and two switch formulas and two measures you get in the visual.
      • 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