Scorecard - Can we add KPI status in text format additional to one in number format ?

[ishwariya11195]

Hi, 

Below is my Scorecard buitt using Power KPI matrix and I want to check if there is a possibility to add one more column "KPI Status"  adjacent to "Status" field which will refelct the status in string linke "Y","N" or "Achieved","Not Achieved".

[Anonymous]

Hi @ishwariya11195 

After my testing, this doesn't seem to be possible.

Here is my test:

I try to reproduce your data and visualizations.

Sample:

Visualizations:

When I create a measure, trying to fulfill your requirements, I find that I can't display the text next to the "Status" field.

Measure 3 = IF(MAX([Value]) < MAX([Target]), "y", "n")

Since this is a custom visual object, you can double-check that it will meet your needs by following the link shown.

Best Regards,
Yulia Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[vs_7]

hi @ishwariya11195 ,

try below steps

1. Create a New Column for Text Statuses: In your dataset, create a new column that maps the numeric statuses to their text equivalents (e.g., "Y" for "Achieved", "N" for "Not Achieved"). This can be done using a calculated column in Power BI.

1. Use a Table or Matrix Visual: Instead of using the scorecard visual, create a table or matrix visual that includes both the numeric status and the new text status column. This visual will serve as your custom scorecard that displays both the numeric and text-based statuses.

1. Customize the Visual: You can further customize this visual by adjusting the formatting options in the Format pane. For example, you can change the font size, color, and alignment to match your report's design.

1. Consider Using a Custom Visual: If you need more flexibility and functionality than what the table or matrix visual offers, you might consider looking into custom visuals available in the Power BI marketplace

[ishwariya11195]

@vs_7 Thank for your inputs on this. I am creating a balanced scorecard for my organisation and need to know whether this is possible in Power KPI matrix.