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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
mnayar
Regular Visitor

Get list of all values of a field selected in Field Parameters

Expected Output for Measure - "a, b, c" or "x, y, z" 

Current Output - "category 1" or "category 2"

mnayar_3-1689953306449.png

 

Current Measure - 

concatenated values = VAR __SelectedValue =
SELECTCOLUMNS (
SUMMARIZE ( Parameter, Parameter[Parameter], Parameter[Parameter Fields] ),
Parameter[Parameter]
)
RETURN CONCATENATEX ( __SelectedValue, Parameter[Parameter], ", " )

 

 

I have a field parameter

mnayar_2-1689953193801.png

 

Table 1:

mnayar_0-1689953086559.png

 

Table 2:

 

mnayar_1-1689953143224.png

 

 

1 REPLY 1
AnthonyGenovese
Resolver III
Resolver III

Field parameters doesn't work like that. 

What I would recommend you do is in Power Query, merge and pivot your data so it looks like this

Cat 1, A

Cat 1, B

Cat 1, C

Cat 2, X

Cat 2, Y

Cat 2, Z

 

That way you can create a relationship to your parameter table or simplye use a slicer from the table you created. 

 

If this post was helpful, please kudos or accept the answer as a solution.
~ Anthony Genovese
Need more PBI help? PM me for affordable, dedicated training or consultant recomendations! 

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.