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

Katiek the date column that you have on the slicer is from the same table?
If the target values and the dates on the slicer are from different tables you need to link them.

Katiek's avatar
Katiek
Helper II
2 years ago

Hi _AAndrade 

The 2 tables are linked together through the field year.

 

  • 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.