Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |