Forum Discussion

Katiek's avatar
Katiek
Helper II
2 years ago
Solved

Dynamic Target in KPI Card

Hi Everyone,  Our targets for employee injuries change every year. In the KPI card i want to see the target for the year that i select in the slicer.   I have the following table called Targets ...
Need Help
  • _AAndrade's avatar
    _AAndrade
    2 years ago

    Hi Katiek,

    Take a look at my simple example:
    I create a table with this data:

    I used this DAX measure:

    TargetYear = MIN(T_Targets[Target])

     

    And the value in the card visual changing according to the value from the Year of the slicer. Here is an example:


    If you could share more information about your model or share a pbix file with same that I could help you

     

_AAndrade's avatar
_AAndrade
Resident Rockstar
2 years ago

Hi Katiek,

 

It depends on how you build your model, but try the following:
MIN('YourTableName'[Target])

Katiek's avatar
Katiek
Helper II
2 years ago

Hi _AAndrade 

Thanks but this just gives me the minimum value in the table, regardless of what year in the slicer I select.

 

Thanks, KatieK