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

Dear Dale,

 

Thanks and appreciated for your prompt response, understood your solution.

 

But in my case i have number of KPIs in one page, management need to review monthly & quarterly trend as a same time.

 

Is there any other visual which entertain my query?

 

REGARDS...

WAQAR

bsas's avatar
bsas
Post Patron
8 years ago

Use funtion "Edit interaction" in format tab. Or you can use DAX function ISFILTERED to show different values based on slicer.

  • 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