Forum Discussion

MSC's avatar
MSC
Helper III
4 years ago
Solved

Use two identical slicers for same visual

Hi everyone!

 

I`d like to create some basic benchmarking in PIB and for this reason want to compare data from different companies with each other.

 

In a first, I aimt to select focal company with slicer 1. Then, I`d like to select peer companies for benchmarking by means of slicer 2. (Both slicers use the same company column in my dataset.) Based on these selections, a visual should afterwards ideally display data from the focal companies as well as from its selected peers.

 

Below, you`ll find a quick draft of what I`m looking for. How is it possible to include the company from slicer 1 in the visual?

 

Thank you very much in advance for any help! 🙂

 

Need Help
Show and Tell
Tips and Tricks
  • MSC's avatar
    MSC
    4 years ago

    Hi v-xulin-mstf 

     

    Thanks for your suggestion, very helpful! I`ve tried to use it with the structure of my data and think we`re already very close to what I`m looking for. Please find attached my page based on your solution.

     

    There are basically two things which I still need:

    - How is it possible to select multiple peers at once, say A, B, and C and compare it with our focal company D?

    - Is there an "easy" way to exclude the company selected as focal company in the pool of peers available for comparison? E.g. I first select company D as our focal company and then only A, B, and C should be available for selection.

     

    PBI_Selection_Suggestion Link 

     

    Thanks a lot in advance!

  • v-xulin-mstf's avatar
    v-xulin-mstf
    4 years ago

    Hi MSC

     

    Try measure as:

    Measure = 
IF(
    MAX(Data[Company]) IN ALLSELECTED(Company_peers[Peers]) || MAX(Data[Company]) IN ALLSELECTED(Company_focal[Focal]),
    1,
    BLANK()
)

     

    For the second requirement you describe, dynamic filtering of two dimension tables at the same time is not supported.

     

    If you still have some question, please don't hesitate to let me known.‌‌

     

    Best Regards,

    Link

     

    Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

     

8 Replies

  • v-xulin-mstf's avatar
    v-xulin-mstf
    Community Support
    4 years ago

    Hi MSC,

     

    Create two dimension table as:

    Company_dim1 = 
VALUES('Table'[Company])
    Company_dim2 = 
VALUES('Table'[Company])

    Create measures as:

    Dim1 = 
CALCULATE(
    MAX('Table'[Sales]),
    FILTER(
        'Table',
        'Table'[Company]=ALLSELECTED(Company_dim1[Company_dim1])
    )
) 
    Dim2 = 
CALCULATE(
    MAX('Table'[Sales]),
    FILTER(
        'Table',
        'Table'[Company]=ALLSELECTED(Company_dim2[Company_dim2])
    )
)

    Here is the output:

    The demo is attached, please try it.

     

    If you still have some question, please don't hesitate to let me known.‌‌

     

    Best Regards,

    Link

     

    Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

    • MSC's avatar
      MSC
      Helper III
      4 years ago

      Hi v-xulin-mstf 

       

      Thanks for your suggestion, very helpful! I`ve tried to use it with the structure of my data and think we`re already very close to what I`m looking for. Please find attached my page based on your solution.

       

      There are basically two things which I still need:

      - How is it possible to select multiple peers at once, say A, B, and C and compare it with our focal company D?

      - Is there an "easy" way to exclude the company selected as focal company in the pool of peers available for comparison? E.g. I first select company D as our focal company and then only A, B, and C should be available for selection.

       

      PBI_Selection_Suggestion Link 

       

      Thanks a lot in advance!

      • v-xulin-mstf's avatar
        v-xulin-mstf
        Community Support
        4 years ago

        Hi MSC

         

        Try measure as:

        Measure = 
IF(
    MAX(Data[Company]) IN ALLSELECTED(Company_peers[Peers]) || MAX(Data[Company]) IN ALLSELECTED(Company_focal[Focal]),
    1,
    BLANK()
)

         

        For the second requirement you describe, dynamic filtering of two dimension tables at the same time is not supported.

         

        If you still have some question, please don't hesitate to let me known.‌‌

         

        Best Regards,

        Link

         

        Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

         

    • MSC's avatar
      MSC
      Helper III
      4 years ago

      amitchandakThank you for the quick response! I`ve to admit that I still don`t know how to approach my problem because in the videos you only use one slicer, right? How does the independent table help with two slicers?