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.