Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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/
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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/
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Problem solved!
thanks!
John
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |