Forum Discussion

waqar's avatar
waqar
Helper I
8 years ago

KPI

Hi Concern,   Hope you are fine.   with referece of last KPI dashboard prepared below custom KPI visual, this time i need to show the difference value between actual and target on visual.   kP...
Need Help
Tutorial Requests
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi waqar,

 

The value we can see from the visual is Actual value. Though we can add a measure of difference to the Actual value field, this could be confusion. Do you mean you want show up +20,000 USD in the visual? If so, I'm afraid this feature isn't supported by this visual.

 

Best Regards!

Dale

  • waqar's avatar
    waqar
    Helper I
    8 years ago

    Hi Dale,

     

    Yes, i want to show the differnce value on visual and respective percentage of actual over target.

     

    Like visual show 20,000 (+20%).

     

    Any other visual entertain this query ?

     

     

    REGARDS...

    WAQAR

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

      Hi waqar,

       

      How about this Multi-row Card visual?

       

      Difference = [SumActual] - [SumTarget]
      %Difference = DIVIDE([Difference], [SumTarget],0)

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

      Best Regards!

      Dale

      • waqar's avatar
        waqar
        Helper I
        8 years ago

        Apprecaite your effort,

        i have 36 tiles on one page, multi row visual can work if we have only 2 3 visual on page.

         

        I need a visusal to entertain my query without comprising my attached format.

         

        REGARDS..

        WAQAR