Forum Discussion
Adding Measure Names Filter/Slicer for Table Visual in Power BI
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
1 Reply
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-fc4095ae9afd
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-299a0ae3725fPower BI Dynamic Format Strings for Measures| Format without converting to text: https://youtu.be/qHALucET7N8
