Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
Can different "what if parameters" be arranged in a column , to have dynamic values
Thanks,
Yogi
Solved! Go to Solution.
Hi @yogeshmaney ,
We can try to create a calculated table and a measure to meet your requirement:
Calculated table:
ParameterName = {"Item1","Item2","Item3"}
Measure:
ParameterValue = SWITCH(SELECTEDVALUE('ParameterName'[Value]),"Item1",[Item1 Value],"Item2",[Item2 Value],"Item3",[Item3 Value])
If it doesn't meet your requirement, kindly share your sample data and expected result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.
Best regards,
Item | Parameter Value |
Item A | Parameter 1 |
Item B | Paramenter 2 |
Item C | Parameter |
Have Created 3 What if parameters, Now Want to arrange /list them in a column , so to have dynamic values for Items.
How can we do this
Thanks,
Hi @yogeshmaney ,
We can try to create a calculated table and a measure to meet your requirement:
Calculated table:
ParameterName = {"Item1","Item2","Item3"}
Measure:
ParameterValue = SWITCH(SELECTEDVALUE('ParameterName'[Value]),"Item1",[Item1 Value],"Item2",[Item2 Value],"Item3",[Item3 Value])
If it doesn't meet your requirement, kindly share your sample data and expected result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.
Best regards,
Hello ,
Its nice but do we get Total .
But its awesome.
Thanks,
Yogi
Hi @yogeshmaney ,
We can use the following measure to correct total value:
ParameterValue = SUMX(DISTINCT('ParameterName'[Value]),SWITCH([Value],"Item1",[Item1 Value],"Item2",[Item2 Value],"Item3",[Item3 Value]))
Best regards,
Simply Awesome ! No words !
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
71 | |
70 | |
43 | |
31 | |
26 |
User | Count |
---|---|
89 | |
49 | |
44 | |
38 | |
37 |