Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Use Slicer as VAR

Hi all, hoe someone can help me with the following.

Below is a VAR REPAIRCODE with a fixed value A01 1 RN 26.

Now I want to be able to change this value, using a slicer.

I have already created a slicer with two values, by using a simple table.

Is it now possible to change the VAR REPAIRCODE?

Meaning, If I click on A03 1 RP 26, the measure must work with this code instead of A01 1 RN 26.

Thanks!

John

 

 

 

 

 

 

 

Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, Anonymous 

    Please try the below.

     

    VAR repaircode = selectedvalue (SlicerTableName[repair_code])

     

    Hi, My name is Jihwan Kim.

    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

    Linkedin: https://www.linkedin.com/in/jihwankim1975/

2 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    5 years ago

    Hi, Anonymous 

    Please try the below.

     

    VAR repaircode = selectedvalue (SlicerTableName[repair_code])

     

    Hi, My name is Jihwan Kim.

    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

    Linkedin: https://www.linkedin.com/in/jihwankim1975/

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Problem solved!

      thanks!

      John