Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Is it possible to create a similar report/visual?

I want to create a visual/ table report with indicators like the following (the one highlighted in green). Is this possible??

 

 

Need Help

13 Replies

  • ankitpatira's avatar
    ankitpatira
    Icon for Community Champion rankCommunity Champion
    10 years ago

    Anonymous are you after traffic light indicators in powerbi ?

    • Anonymous's avatar
      Anonymous
      Not applicable
      10 years ago

      Sean

       

      I tried the approach mentioned in the link, but I am not able to see the option Preview Features > Use KPIs from Power Pivot or SSAS Tabular in the Option and Setting tab. Is thia preview feature no longer available?

       

      • Sean's avatar
        Sean
        Icon for Community Champion rankCommunity Champion
        10 years ago

        Anonymous It seems this feature has been enabled by default in the latest PBI - so don't worry it will work!

         

        However don't forget you still have to create the KPIs in Excel PowerPivot and then import into PBI

         

         

         

    • Anonymous's avatar
      Anonymous
      Not applicable
      10 years ago

      Hi Sean, 

       

      I have followed your instruction and created kpi in powerpivot. 
      When I import to PBI desktop, the kpi (or the pivotpivot table) is not found. But when I import to PowerBI onilne, the kpi is there. 

      May I know how to correct this?

       

      Many thanks.

      • Sean's avatar
        Sean
        Icon for Community Champion rankCommunity Champion
        10 years ago

        Are you using the latest version of the PBI Desktop?

         

        2.34.4372.501 64-bit (April 2016)

         

        If not you may have to turn on the Preview Features (see Vanessa's post and picture on Page 1)

    • ireneapplebe's avatar
      ireneapplebe
      Frequent Visitor
      9 years ago

      Hi, I'm trying to create traffic light indicator and I have data model already created using Powerviot.

      After created data model using Powerviot, I have created KPI spreadsheet and this is loaded to PowerBI.

      However, when I create table using data source loaded, it does not show traffic light indicator but showing "-1" or "1" value instead.

      Can anyone let me know how should I go about this?

       

      Thanks in advance!