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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Syndicate_Admin
Administrator
Administrator

Help with a SELECTEDVALUE formula

I need to be able to reference in a SELECTEDVALUE to any of these fields in the parameter group.

This is the parameter of fields:

RomanG123_0-1680606600124.png

RomanG123_2-1680606641713.png

RomanG123_4-1680606864423.png

This is the formula I need to fix:

RomanG123_6-1680606980163.png

I would need to know how to reference well to the parameter within the formula.

Thanks in advance

2 REPLIES 2
Syndicate_Admin
Administrator
Administrator

Thank you!

goncalogeraldes
Super User
Super User

Hi  what I usually do instead of using data groups in fiel parameters is to change a bit the code on the parameters itself to manually generate the group like this: 

 

 

Field Param Example = {
    ("Country", NAMEOF('Customers'[Country]), 0, "Group 1"),
    ("Region", NAMEOF('Customers'[Region]), 1, "Group 1"),
    ("City", NAMEOF('Customers'[City]), 2, "Group 1"),
    ("Address", NAMEOF('Customers'[Address]), 3, "Group 1"),
    ("Country", NAMEOF('Customers'[Country]), 0, "Group 2"),
    ("Region", NAMEOF('Customers'[Region]), 1, "Group 2"),
    ("City", NAMEOF('Customers'[City]), 2, "Group 2")
}

 

 

goncalogeraldes_0-1680608149951.png

@Syndicate_Admin

 

This way I think its easier to use the SELECTEDVALUE() function on the field parameter itself.

 

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!

You can also check out my LinkedIn!

Best regards,
Gonçalo Geraldes

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors