Indicator on a card

[Anonymous]

I want to add a KPI indicator on a card, I created a measure with the following formula then i dragged the measure into the fields section just like other fields but instead of showing up next to "Average of SkuInventory, it shows up on top of Capacity instead and i don't know why. Please help.

KPI = SWITCH (

TRUE (),

Sales_Inventory[Skuinventory] > 60, UNICHAR(9650),

Sales_Inventory[Skuinventory] >=40 && 'Sales_Inventory'[Skuinventory] < 60,UNICHAR(9660),

Sales_Inventory[Skuinventory] < 40,UNICHAR(9670),

"---"

)

[Anand24 · Accepted solution]

Hi @Anonymous ,

This happens when you take only one field(bei it column or measure) with datatype text in your multi-row card.

Power BI considers it as a categorical value for which multiple KPIs are shown.

You will need to add another text datatype field to the values so that your indicator can be placed to right of "Average of SkuInventory".

What you can do is create a new blank measure/column(measure=" ") and pull it to the values. Now to will just have to hide this new measure's label(disable label or rename it to .(dot) or place a rectangle infront of it or whatever tweak you figure out).

Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!

[Anand24 · Accepted solution]

Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!

[Anand24 · Accepted solution]

Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!

[Anonymous]

@Anand24 

Thanks so much, it worked though turning the new field to a dot creates a space that cannot be removed in the card even after resizing but your suggestion worked. If you know the way to remove the space that would be greatly appreciated. Thanks again

[FrankAT]

Hi @Anonymous 

I reproduced your issue in multi-row card. The visuals suspects your measure as the title. I Think it's a bug. Can @amitchandak agree?

Regards FrankAT