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

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! 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
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.