Forum Discussion

vipinkmathews's avatar
vipinkmathews
Advocate III
8 years ago

How to create status indicator field?

I want to display green, orange, red etc. circle indicators in a status column of the table based on the revenue or gross margin%.

I could not understand how to create the status indicator column. But I have seen the same from the Power BI samples.

I could see that it appears like a hierarchy structure (eventhough it's not) in the Fields section with indicator icon.

 

PFA the samples from the IT Spend Analysis sample & Customer profitability sample.

 

I would like to know how the hierarchical kind of structure is created and is there any DAX code has to be written for status column based on revenue? I couldn't see any of these columns in the DataView tab but it is present only in the Fields Section

 

 

Need Help

4 Replies

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    8 years ago

    Hi vipinkmathews,

    In the sample table, the status indicator(KPI) is created in Excel Power Pivot, then add the Power Pivot model into Desktop, so you can see it as the screenshot shown, more details, please see the article. Then import the API into Power BI desktop, please review:Import and display KPIs in Power BI.

    Besides you create a KPI in Power Pivot, you can create a calculated column or measure using unicode, more deatils, please review this article.

    Best Regards,
    Angelia

    • shill1000's avatar
      shill1000
      Helper IV
      8 years ago

      I've been asked a similar question, and I suspect the answer is to create a specific visualisation or wait until someone else does it.

       

      We have a RAG status requirement but there are 5 values - red, amber, green, blue and grey. traffic ligths and gradients are no use because they deal with colour ranges, not multiple absolute values (at least no more than 3). Anyone know how to get the value to appear as one of 5 colour coded icons?

    • vipinkmathews's avatar
      vipinkmathews
      Advocate III
      8 years ago

      Thank you very much for the response. 

      I thought that the indicator in the example was created directly from power bi desktop.

      Kind Regards

      Vipin