Forum Discussion
Microsoft Default KPI Visual
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 )
Hi KF2003
Below is the DAx measure you can use to work as expected using ISFILTERED().
Total Actual =
IF(
ISFILTERED(table_name[PartnershipName]),
SUM(table_name[Amount]),
CALCULATE(SUM(table_name[Amount]), ALL(table_name))
)
😊 If this post helped you, feel free to give it some Kudos! 👍
✅ And if it answered your question, please mark it as the accepted solution.