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

     

Katiek's avatar
Katiek
Helper II
2 years ago

_AAndrade 

oh my gosh, i just figured it out. I changed the filter direction in the relationship to both and it worked.

Thank you so much for your help. This problem has been on my mind and taking forever to solve.

_AAndrade's avatar
_AAndrade
Resident Rockstar
2 years ago

Great. As I thought is a relationship issue.
By the way, good practice says that the correct relationship between the "Date" table and the destination should be "One to many", so the date table should filter the destination table and not the other way round.
This relationship will works fine as well.