Forum Discussion

sobm_1092's avatar
sobm_1092
Regular Visitor
2 years ago
Solved

Dynamic Calculation based on the slicer selection

I am new to Power BI and I am stuck with this problem.   I have a dataset that has multiple columns. I want to create two slicers based on a single column `ID`, One is Base and the other is Referen...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

Slicer is what i have used on the page.  I have done it with a single slicer.  The user can select any 2 options in the single slicer.

sobm_1092's avatar
sobm_1092
Regular Visitor
2 years ago

Pic 1

Pic 2Pic 3

 

Please see the attached Images. I have added another case A3-2020, I want to implement 2 different slicer. But after i choose Base id slicer, reference Id slicer shows the same value. How can i overcome this. 

 

Thanks a lot for your response.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    2 years ago

    That will just complicate the solution.  When you can achieve your desired result with a single slicer, why are you creating another one?

    • sobm_1092's avatar
      sobm_1092
      Regular Visitor
      2 years ago

      You are correct about complicating things but I was facing the same issue with 2 slicer on same column. I tried but I couldn't do so. That's why I wanted to do this.

      Thanks a lot for your prompt response, you have helped me a lot. 

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        2 years ago

        You are welcome.