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 Power BI Experts,
I'm currently working on a Power BI dashboard where I have a table visual displaying various measures, most of which are durations from IVR data. To provide flexibility to our users, we want to implement a measure names filter or slicer that allows them to select the specific measures they want to display in the table visual.
The challenge is that we have over 35 different durations, all of which are in HH:MM:SS format after conversion from seconds/milliseconds. We're seeking advice on how to create a dynamic measure names filter/slicer that enables users to choose the measures they're interested in viewing.
Any insights, suggestions, or step-by-step instructions on how to achieve this in Power BI would be highly appreciated.
Thank you in advance for your help!
Best regards,
Manoj Prabhakar
@manoj_0911 , I think you should have kept them in Second and milli second and created measure. Then you can create calculation groups (now you can created from Model view) or field parameters. For format to HH:MM:SS use the measure format
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
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
Power BI Dynamic Format Strings for Measures| Format without converting to text: https://youtu.be/qHALucET7N8
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
60 | |
55 |
User | Count |
---|---|
179 | |
108 | |
105 | |
71 | |
70 |