Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
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 , 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
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.