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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
bigwall
New Member

Field Parameter String Output

TL;DR. I would like to be able to get the SELECTEDVALUE of a field parameter the same as a normal slicer which I think is a very simple request. And as a second request that might violate the spirit of PowerBI, I'd like to get the output of a field parameter. If not always, at least when its a categorical dimension. Now on to my more detailed rant 🙂


I have been using field parameters and I think there is a very simple feature missing. There should be an additional component that returns the chosen label. I am unable to create a dynamic title because the only thing that returns a usable string is the Field Parameters argument which includes an uncleaned table name. I ran into an issue yesterday trying to dynamically switch a measure accompanying the field parameter output, a measure recreating the GT of column feature. Today I have run into the same issue trying to use dynamic titles the way they can normally be used. I can use an additional measure that uses the field parameters and then outputs a chosen cleaner string but it seems to me that this is a simple feature to add. Should I make a feature request? I don't know the utility of such an action.

Additionally it would be nice to have an additional component that would allow the values of the field parameter to be usable in a slicer. For example, If I want to use a field parameter to combine Year, Quarter, and Month columns so I can switch the date axis between those (especially if I am using a custom time grouping), I can do so. But I have no way to then have a second single slicer  that will show the Years if Year is selected, so I can filter for a given year. On various projects I have spent a disappointing amount of time creating a way to switch between date levels and I thought field parameters were the solution but they are only half of what I need. Basically I want slicer 1 to say Year, Quarter, Month. And I want Slicer 2 to say 2020, 2021, 2022 if I select Year, Q1 2020...Q4 2022, if I select Quarter, and 2020 January... 2022 December if I select Month. I always have to create my own columns because of the way PowerBI always sorts Q1 before Q2 no matter which year it is, same with months. I recall that there is a way to drill down that shoudl work but then again half the projects I have worked on have had custom ways of grouping into weeks/months/quarters/years so even then I still would need field parameters to do what I want to work right. But now I am rambling.

1 REPLY 1
amitchandak
Super User
Super User

@bigwall , You can get the selected value in case of field parameter like

 

Selected Axis = maxx(FILTER('Axis Slicer', 'Axis Slicer'[Axis Slicer Order] = SELECTEDVALUE('Axis Slicer'[Axis Slicer Order])), 'Axis Slicer'[Axis Slicer])

 

Selected Measure = maxx(FILTER('Measure Slicer', 'Measure Slicer'[Measure Slicer Order] = SELECTEDVALUE('Measure Slicer'[Measure Slicer Order] )), 'Measure Slicer'[Measure Slicer])

 

I discussed the same in the Community webinar and shared 3 files in the comments

https://community.powerbi.com/t5/Webinars-and-Video-Gallery/Power-BI-Community-Show-Episode-10-Makin...

 

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
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

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.