Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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.
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?
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.
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.
User | Count |
---|---|
117 | |
73 | |
58 | |
49 | |
48 |
User | Count |
---|---|
171 | |
122 | |
60 | |
59 | |
56 |