Forum Discussion

SC_Developer's avatar
SC_Developer
Frequent Visitor
3 years ago
Solved

Switch between Measures based on Visual

Hi 🙌🏻

 

I am new to this community.

 

I am looking for a solution to write a Measure that switches between

  • Measure A when used as a value in Visual A and
  • Measure B when used as a value in Visual B

I want to insert it into a single Field Parameter Slicer that works for both Visual A and B.

 

 

Thanks for your support.

 

Cheers, Martin

Need Help
  • eliasayyy's avatar
    eliasayyy
    3 years ago

    create the same fields parameter for each visual , 

    so for visual A you will have the field emsaure , order and name 
    same as for visual B

    create a relationship between the order column of the 2 paramters

    now when you select your slicer paramter , both will get affected based on the emasure you want just make sure for visual a you have the paramter you made for visual a and for visual b you have the paramter you made for visual b

2 Replies

  • eliasayyy's avatar
    eliasayyy
    Memorable Member
    3 years ago

    create the same fields parameter for each visual , 

    so for visual A you will have the field emsaure , order and name 
    same as for visual B

    create a relationship between the order column of the 2 paramters

    now when you select your slicer paramter , both will get affected based on the emasure you want just make sure for visual a you have the paramter you made for visual a and for visual b you have the paramter you made for visual b

    • SC_Developer's avatar
      SC_Developer
      Frequent Visitor
      3 years ago

      eliasayyy Thanks a lot for your quick help! 

       

      I needed to make sure to only have one slicer on the page and now it works.