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
sobm_1092's avatar
sobm_1092
Regular Visitor
2 years ago

Thanks a lot. Is it possible to do with slicer, cause there is multiple values in the ID column, like A1-2020, A1-2021, A1-2022, A2-2020, A2-2021, A2-2022. From there user can select which one they want as a base and which one they want as reference. 

  • 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?