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 in Excel (user hides the days when he did the training, but database is kept intact).

 

This is how the target for the KPI visuals looks like (same database file, different tab):

 

 

What i am failing to do is make the dashboard show the correct progression in the KPI visual.
If i put one item as manual measurement it works, but i need 47 measurements so that when i pick an item (exercise) its hows how far or after the KPI the user currently is.

 


Attached are my files:
- Excel database: https://pixeldrain.com/u/rNUMkwzo
- PowerBi Dashboard: https://pixeldrain.com/u/cs9RUvcj

 

Thank you very much for your help in advance for any tips!
Warm regards,
Texnoi

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()
)

     

     

7 Replies

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