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

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
bmcminn
Helper II
Helper II

Dynamically choosing which field to use in measure like MAX, field parameter not working as expected

Hello. I am making a data profiling report for a client. It's very similar to what is available in the query editor under column profile. I have no problem getting the histogram with the value distribution but am stuck on how to show any of the quantitative measures. I thought it would be straightforward and that I can just put the parameter into a measure but none of the different ways I've tried have worked. I am including a mock data set and report. The report has a static page of what I'm trying to get to and another page with the things I've tried. Thanks ahead of time for any help. 🙂

https://drive.google.com/file/d/1OxgQVEXW7BBWddE-w2ILBjl763_IT6cm/view?usp=drive_link 
https://drive.google.com/file/d/1V_D1MqJaFNaKZEep4nxYQH95QNxYIZ3P/view?usp=drive_link 

 

Here's an image of the static mock-up.

bmcminn_0-1693942821070.png

 

2 REPLIES 2
amitchandak
Super User
Super User

@bmcminn , Have you tried field parameters and calculation groups

 

Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE
Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f
Field Parameters- Conditional Formatting
: https://amitchandak.medium.com/field-parameters-conditional-formatting-517aacc23fdf

 

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0

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

I don't think any of these answer the questions I posed. None of them address using a field paremeter in a measure, or any other way to choose which fields go into a parameter. And my organization only wants to use OOB features w/ PBI due to security.

Any other ideas please?

I really feel like this should be something that can be done OOB.

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

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

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