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 Community!🤗
I tried to search here on the forum and on youtube about the "new" Field functionality.
But the new functionality is still confusing to me in what I want.
Normally I use switch I filter everything by a single variant. example;
Dynamic Dur =
var _selectedDur=SELECTEDVALUE(REF[IMGREF])
return
SWITCH(
_selectedDuration,
"Plan1", SELECTEDVALUE('Plan1'[Dur]),
"Plan2", SELECTEDVALUE('Plan2'[Dur]),
"Plan3", SELECTEDVALUE('Plan3'[Dur]),
"Plan4", SELECTEDVALUE('Plan4'[Dur]),
"Plan5", SELECTEDVALUE('Plan5'[Dur]),
BLANK()
)
And another mensure;
Dynamic Fin =
var _selectedFin=SELECTEDVALUE(REF[IMGREF])
return
SWITCH(
_selectedDuration,
"Plan1", SELECTEDVALUE('Plan1'[Fin]),
"Plan2", SELECTEDVALUE('Plan2'[Fin]),
"Plan3", SELECTEDVALUE('Plan3'[Fin]),
"Plan4", SELECTEDVALUE('Plan4'[Fin]),
"Plan5", SELECTEDVALUE('Plan5'[Fin]),
BLANK()
)
I create several measures based on filter in SELECTEDVALUE(REF[IMGREF]).
How do I do this with Modeling/New Parameter/Fields?
I tried here relation, but without success.
thanks!
Hi, @Peleias,
not quite sure what your issue is. Have you enabled the preview feature? Or is it enabled, but you are having issues creating the parameters?
Cheers,
Sturla
Hi @sturlaws, My doubt is how to control 5 different Fields, each with 3 options. Similar as I do with switch.
In the case filter in SELECTEDVALUE(REF[IMGREF]) controls the switches.
This column has 5 units (Plan1, Plan2, Plan3, Plan4, Plan5).
Each PlanN has 3 columns.
Selecting Plan1, you will have the columns Plan1[Fin], Plan1[Dur], Plan1[Sta] highlighted.
Selecting Plan2, you will have the columns Plan2[Fin], Plan2[Dur], Plan2[Sta] highlighted.
➡️That is SELECTEDVALUE(REF[IMGREF]) controls the visibility of 3 columns.
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |