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

     

     

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.

    • AmiraBedh's avatar
      AmiraBedh
      Super User
      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()
)

       

       

      • texnoi's avatar
        texnoi
        Regular Visitor
        3 years ago

        Thank you it did help! What if i want to combine values from 3 databases:

        For example just for the box squat: I want to combine Reps1+reps2+Reps3+Reps4+Reps5 so that i use their data as well. Is it still the Dynamic Range command i need? 

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