Forum Discussion
Power KPI Matrix Formatting
Thanks v-kathullac for the response. I suspected that your points 1, 2 were causing the blanks but was unsure if there was some way to coerce ther KPI matrix to show them anyway.
On 4), perhaps I have a different version of PBI Desktop, but there is no formatting option in my modeling tab. I can get to formatting options for a particular measure using the Measure Tools tab. The measures that I want are set to be whole numbers, with commas and no decimal places. However the KPI matrix still shows the first decimal place (which is what the All Metrics are set to). So if the true value is 1,234.6, I would like it to show 1,235, not 1,235.0. I think given the limitations of the Power KPI Matrix it is just not possible to have different formatting in different rows in the same matrix. I think the only solution is to just stack 2 KPI matrices and use different but consistent formatting, in each of them.
I am not sure if I can mark my own post as the solution, but if I can I may do so to close the topic. The short answer seems to be that it is unsolveable- the KPI Power Matrix requires consistent formatting within columns, even though it appears to offer other options. The best option is to use mutliple KPI matrices broken down by required formatting.
I do appreciate the responses and the attempts to help- thank you both very much.
Hopefully a developer will redo the Power KPI matrix or something similar to fix these issues. Even better would be a more flexible matrix format for visualizations.
Thanks again
Hi hskog 👋
You're absolutely right to expect that Power KPI Matrix should support row-level formatting, especially when dealing with a mix of whole numbers and decimals. However, this is a known limitation in the way the Power KPI Matrix custom visual handles formatting, particularly when you try to define different formats for each row across metrics (Actual, Target, KPI Indicator).
✅ Workaround:
The most consistent workaround I've found is to explicitly control the formatting at the DAX level by formatting the measure as a string. Here's what you can do:
Format measures as text in DAX:
FormattedMeasure_Whole = FORMAT([YourMeasure], "#,0")
FormattedMeasure_Decimal = FORMAT([YourOtherMeasure], "#,0.0")
Then, use these formatted text measures in your KPI Matrix.
Yes, this means sacrificing numeric properties like sorting or conditional formatting, but it ensures consistent formatting.
⭐Hope this solution helps you make the most of Power BI! If it did, click 'Mark as Solution' to help others find the right answers.
💡Found it helpful? Show some love with kudos 👍 as your support keeps our community thriving!
🚀Let’s keep building smarter, data-driven solutions together! 🚀