Power KPI Matrix - Time Format

[wandrade]

Hello!

Does anybody know can I change the format of a row-based KPI to be shown in minutes : seconds, using the Power KPI Matrix visual in Power BI?

I know it can be changed to currency or % using the syntax $, 0.00 or #,0.00%, respectively; however I do not know which syntax to use for the Current Value and Comparison Value to be displayed in mm:ss format (this is a KPI for a call center's handle time, which is in minutes : seconds).

Any help would be greatly appreciated.

[Anonymous]

I am having the exact same issue, using a dashboard to display KPI data.  Is there a way to format individual metrics for time, as in the example above? 

[v-xiaotang]

Hi @wandrade 

Thanks for reaching out to us.

I just want to confirm if you resolved this issue? If yes, you can accept the answer helpful as the solution or share you method and accept it as solution, thanks for your contribution to improve Power BI.

If you need more help, please let me know.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[wandrade]

Hi! I still have not figured out how to solve this, I tried Shaurya's advice but it dodn't work. Could you help me? I believe this must be somehting in the syntax, I mean if we can display the results in % and $ we should be able to show time as well, I'd say. 

[Shaurya]

Hi @wandrade,

Extract the minute and seconds part and store it in a new column. Use that column as the field in your card.

Column = CONCATENATE(CONCATENATE(CONVERT(MINUTE('Table'[Time]),STRING),":"),CONVERT(SECOND('Table'[Time]),STRING))

Mark this post as a solution if that works for you!
Check out this blog of mine: How to Export Telemetry Data from Azure IoT Central into Power BI

[wandrade]

thanks for your reply. I tried this but it didn't work, since this has be tied to the row-based metric, when I add a second field to the Row Base Metric name it messes up all the other KPIs.