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.
Hi, all
I really want to ask that Is there any way to pass measure in field parameter instead of normal measure
For example
Thankyou
Best Regard
firstch
Solved! Go to Solution.
@firstch
Cannot think of a more efficient approach than this but should work. Incoorporate this code within your measure
VAR __PARAM = SELECTEDVALUE( Parameter[Parameter Order] )
RETURN
SWITCH(
TRUE(),
[Filed Measure 1] = __MAXSALES && __PARAM = 0 , "COLOR CODE1",
[Field Measure 2] = __MAXSALES && __PARAM = 1 , "COLOR CODE1",
"COLOR CODE2"
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@firstch
Cannot think of a more efficient approach than this but should work. Incoorporate this code within your measure
VAR __PARAM = SELECTEDVALUE( Parameter[Parameter Order] )
RETURN
SWITCH(
TRUE(),
[Filed Measure 1] = __MAXSALES && __PARAM = 0 , "COLOR CODE1",
[Field Measure 2] = __MAXSALES && __PARAM = 1 , "COLOR CODE1",
"COLOR CODE2"
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
7 | |
7 | |
6 | |
6 |
User | Count |
---|---|
27 | |
12 | |
10 | |
9 | |
6 |