Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Indicator on a card

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),
"---"
)
 
 
  • 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 !!!

     

     

3 Replies

  • 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 !!!

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      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's avatar
    FrankAT
    Icon for Community Champion rankCommunity Champion

    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