Forum Discussion

manoj_0911's avatar
manoj_0911
Kudo Commander
2 years ago

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...
Need Help
amitchandak's avatar
amitchandak
Super User
2 years ago

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

https://powerbi.microsoft.com/en-us/blog/deep-dive-into-the-model-explorer-with-calculation-group-authoring-and-creating-relationships-in-the-properties-pane/

 

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-299a0ae3725f

 

Power BI Dynamic Format Strings for Measures| Format without converting to text: https://youtu.be/qHALucET7N8