Forum Discussion
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 ...
Hi Anonymous,
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.