Use Slicer as VAR

[jwi1]

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

[Jihwan_Kim · Accepted solution]

Hi, @jwi1 

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/

[jwi1]

Problem solved!

thanks!

John