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

bsas's avatar
bsas
Post Patron
8 years ago

Hi,

 

Create moth and quarter calculated columns and then use them as slicers.

 

e.g. for quater

 

Quarter = FORMAT(Months[StartOfQuarter], "yy") & " Q" & Months[StartOfQuarter].[QuarterNo]

or

QuaterShort = "Q" & Months[StartOfQuarter].[QuarterNo]

 

for month

Month = FORMAT(Months[Date], "MMMM") {also use index column to sort names correctly - MonthIndex = Months[Date].[Year] * 100 + Months[Date].[MonthNo]}

or

MonthShort = FORMAT(Months[Date], "MMM")