Forum Discussion

waqar's avatar
waqar
Helper I
9 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

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
9 years ago

Hi waqar,

 

Could you please provide a sample in text mode? 

1. Do you mean sum up the monthly KPI? Or evaluate Quarterly KPI?

2. How to show up the sum-up values?

3. A slicer could be good filter.

 

Best Regards!

Dale

waqar's avatar
waqar
Helper I
9 years ago

Hi Dale,

 

FInd below sample link of my dashbaord and excel file for data tables.

 

https://app.powerbi.com/view?r=eyJrIjoiNjM3Yzk4NzktZWY1OS00ZTY0LWIyODktZDQzNjMwZDg2NzEyIiwidCI6Ijc3YmExMjk4LTM4NWItNGZmYS04NmY2LWUyYzQ2NDczMjc2YSIsImMiOjl9

 

Excel File Link

https://we.tl/vwDLh5TMSb

 

2. I need to sum up monthly KPI value in Quarter and show up in same tile as one value. like in dashbaoard link  i need a quarter slicer as per fiscal year to show respective quarter value (aggregated) in net profit tile.

 

Hope you clear now,

 

REGARDS...

WAQAR