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
Thanks GrowthNatives for the response. I tried your suggestion of wrapping my measure in a format statement, and putting the values in a regular matrix works fine and they display as needed (but this could also be controlled in other ways). However the Power KPI Matrix shows blanks when I use the text version. Do I need to adjust some other setting?
Hi hskog,
Thank you for reaching out to Microsoft Fabric Community Forum.
There are few limitations while using the power kpi matrix can you follow the below steps to solve the issue.
1)When you wrap a measure using FORMAT() (e.g., FORMAT([Sales], "₹#,##0")), it becomes text, and Power KPI Matrix does not support text values in those fields — hence it shows blank.
2) Power KPI Matrix expects numeric values in these fields: Actual Value,Target Value,KPI Indicatornin these Using text here causes the visual to go blank.
3)Use raw DAX that keeps the result as a number SalesAmountRaw = SUM(Sales[Amount])
4)Select the raw numeric measure Go to Modeling tab > Formatting section Set: Currency symbol, Decimal places, Percentage format (if needed)
5) Create a second measure with FORMAT() If you need to show values with special formatting (₹, %, commas), create a separate measure.
SalesAmountFormatted = FORMAT(SUM(Sales[Amount]), "₹#,##0") Use this second measure only in: Tooltips, Regular Matrix visuals, Card visuals
6) For colors/icons in Power KPI Matrix, use conditional formatting on numeric values.
Click on the visual Go to Format Pane --Data Colors.
Enable conditional formatting -- Set rules based on raw numeric values.
Regards,
Chaithanya.
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