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