Forum Discussion

KF2003's avatar
KF2003
New Member
9 months ago
Solved

Microsoft Default KPI Visual

Hey, Im trying to make a dashboard to track totals for my team. I want to use the native KPI Visual but Id like it to show the teams total and then the goal when nothing is selected. Right now its de...
General Comment
Need Help
  • MasonMA's avatar
    MasonMA
    9 months ago

    Native KPI visual in Power BI is meant for time-based performance tracking. Since your report is for the current month only, you don’t need the KPI visual. I'd suggest using the Card (New) viusal instead:

     

    Set “Value” to Amount and set “Reference label” to Goal Amount
    It will automatically show the team total when nothing’s selected and each partnership’s total when filtered, all power bi implicit measure and no DAX or trend axis needed. 

     

    Change the names and format the card to make it perfect. (here is a tutorial from Guy in a cube showing how to format this visual, https://www.youtube.com/watch?v=aPrh4sK8CX4&t=196s ) 

     

v-echaithra's avatar
v-echaithra
Community Support
9 months ago

Hi KF2003 ,

Just following up to see if the Response provided by community members were helpful in addressing the issue. if the issue still persists Feel free to reach out if you need any further clarification or assistance.


Best regards,
Chaithra E.