Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

KPI card - multiple period (years)

Hi everyone,

 

First time poster, long time viewer.

 

Is it possible for a KPI card to compare actual vs plan across two years (i.e. 24 months)?

 

When I select both years in the filter, only 2020 appears.

Need Help
  • dax's avatar
    dax
    7 years ago

    Hi dever2018,

    Below is my design

    You could create another table like below

    Table 3 = UNION (
      
    VALUES ( t6[date].[Year] ),
   
    ROW ( "subname", "TOTAL" )
)

    Then use this in KPI

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

4 Replies

  • sturlaws's avatar
    sturlaws
    Icon for Resident Rockstar rankResident Rockstar
    7 years ago

    Hi Anonymous,

    have you considered handling it with a measure?

    Revenue =
CALCULATE (
    SUM ( Table[RevenueCol] );
    FILTER (
        ALL ( date );
        year <= SELECTEDVALUE ( year )
            && year
                >= SELECTEDVALUE ( year ) - 1
    )
)
    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Will give it a go - appreciate the prompt response!

  • dax's avatar
    dax
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi dever2018,

    Below is my design

    You could create another table like below

    Table 3 = UNION (
      
    VALUES ( t6[date].[Year] ),
   
    ROW ( "subname", "TOTAL" )
)

    Then use this in KPI

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thanks so much dax ! I created a new column = 1 and insered to the Trend axis. It worked a treat!