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
Atoleto
Frequent Visitor

How to get few columns from one Fields Parameter?

I have few tables ('Oblast' and 'District') with columns named 'Name' and 'shapeID'.
I use 'shapeID' column to identify shape at Mapbox custom visual, and need to build a chart based on 'Name' column.

How can I get these two values from the one Fields Parameter slicer?

My Fields Parameter:

 

LocationSelector = {
    ("District", NAMEOF('District'[shapeID]), 0),
    ("Oblast", NAMEOF('Oblast'[shapeID]), 1)
}

 

If I try to make a new column, like the next, it returns just a text value:

 

LocationName = if(LocationSelector[LocationSelector]="District", NAMEOF('District'[Name]),
         if(LocationSelector[LocationSelector]="Oblast", NAMEOF('Oblast'[Name])))

 

 

 

 

 

1 REPLY 1
amitchandak
Super User
Super User

@Atoleto , Not very clear. But this how you get selected value of field parameter, Assume name is parameter

 

Selected Parameter = maxx(filter(Parameter ,Parameter[Parameter Order] = SELECTEDVALUE(Parameter[Parameter Order])), Parameter[Parameter])

 

 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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