Forum Discussion

texnoi's avatar
texnoi
Regular Visitor
3 years ago
Solved

KPI visualization from excel file

Dear all, I am trying to create a simple training dashboarboard. So far it looks somehow working, but i fail to update the KPI visuals to work properly.  This is how my database looks like...
Need Help
  • AmiraBedh's avatar
    AmiraBedh
    3 years ago

    I created two measures :

     

    Dynamic Average = 
SWITCH(
    SELECTEDVALUE('Data v2'[Exercise]),
    "Box Squat", CALCULATE(AVERAGE('Data v2'[Reps3]),'Data v2'[Exercise]="Box Squat"),
     "BG Squat", CALCULATE(AVERAGE('Data v2'[Reps3]),'Data v2'[Exercise]="BG Squat"),
    BLANK()
)

     

    This measure will calculate the average based on the selection. You can populate it with all possibilities.

    For the target I followed the same logic :

    Dynamic Target = 
SWITCH(
    SELECTEDVALUE('Exercises / Target'[Exercises]),
    "Box Squat", 100,
     "BG Squat", 30,
    BLANK()
)

     

     

AmiraBedh's avatar
AmiraBedh
Super User
3 years ago

I am a little bit lost here ? Which visual is having the issue ?

  • texnoi's avatar
    texnoi
    Regular Visitor
    3 years ago

    Dear AmiraBedh,
    The visual i am strugling with is the KPI Visual.


    What i am trying to do is to have a dynamic visual that changes KPI based on chosen variable (in my case table showing different exercises).

     

    So when i add a filter (Show me all entries from August 2023) and compare with the target (90) i am not getting the correct visual.

    Target is 90. Reached is 70. KPI Visual shows this:

     

    Thank you very much for your help!
    Warm regards,
    Texnoi

     
    • AmiraBedh's avatar
      AmiraBedh
      Super User
      3 years ago

      I can't find any visual with the one you are sharing :


      What i am trying to do is to have a dynamic visual that changes KPI based on chosen variable (in my case table showing different exercises)

      Can you provide an example of the 2 selections and the KPIs you want to show ?

      • texnoi's avatar
        texnoi
        Regular Visitor
        3 years ago

        It is the small KPI visual. It must show the same as the table on the left.

        For example: Target for Box Squat is 100. It should be showed in the KPI visual when the exercise picked from the filter to the right.