Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
Peleias
Helper I
Helper I

One Field control many SELECTIONVALUE (from New Paramenter/Fields)

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!

2 REPLIES 2
sturlaws
Resident Rockstar
Resident Rockstar

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.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.