Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
wandrade
Regular Visitor

Power KPI Matrix - Time Format

 

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.

 

Capture.PNG

 

 

 

5 REPLIES 5
Anonymous
Not applicable

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
Community Support
Community Support

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.

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
Memorable Member
Memorable Member

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

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.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.