The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
80 | |
78 | |
47 | |
39 |
User | Count |
---|---|
148 | |
115 | |
65 | |
64 | |
53 |