Forum Discussion

waqar's avatar
waqar
Helper I
8 years ago
Solved

KPI

Dear Concern,   I prepare an KPI dashboard using below custom KPI visual, I need to sum my monthly KPI value in quarter.   Can anybody help me the procedure to maintain monthly and quarter filter...
Need Help
  • waqar's avatar
    waqar
    8 years ago

    Hi Dale,

     

    Appreciate your effort.

     

    I need one tile for each KPI with dynamic filter of month and quarter, i did it somehow with some alterations. find my working in below link

     

    https://we.tl/fEbbWbtMIE

     

    REGARDS..

    WAQAR

waqar's avatar
waqar
Helper I
8 years ago
I am unable to catch u , Can u plz prepare a sample dashboard as per my data sheet shared with dale
  • waqar's avatar
    waqar
    Helper I
    8 years ago

    Hi Dale,

     

    Appreciate your effort.

     

    I need one tile for each KPI with dynamic filter of month and quarter, i did it somehow with some alterations. find my working in below link

     

    https://we.tl/fEbbWbtMIE

     

    REGARDS..

    WAQAR

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

    waqar,

     

    Hi WAQAR,

     

    Thank you for sharing. Glad you worked it out.

     

    Best Regards!

    Dale

  • waqar's avatar
    waqar
    Helper I
    8 years ago

    Hi Dale,

     

    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.

     

    • kPIIndicator.2.0.1

     

    for example 

     

    Actual = 100,000 USD

    Target = 80,000 USD

    Difference = +20,000 USD (which i need to show on visual with %)

     

    can you plz help me to acheive this objective with any solution available.

     

    Regards...

    WAQAR

    92 333 3035810

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

    Hi waqar,

     

    I'm fine. Thank you. 

     

    Please open a new topic in this forum.

     

    Best Regards!

    Dale

  • waqar's avatar
    waqar
    Helper I
    8 years ago

    okay, done it.

     

    REGARDS....

    WAQAR