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,
You would need use ISFILTERED() to check if slicer is applied. If applied the KPI should show the overall team total/goal, this way the KPI measure detect the filter context and return the correct total with ALL() when needed.
I assume it'd be a measure like this,
measure =
IF(
ISFILTERED('table'[Partnership]),
SUM('table'[Amount]),
CALCULATE(SUM('table'[Amount]), ALL('table'[Partnership]))
)
Hey, Im like crazy new to Power BI, I've been teaching myself by converting an excel dashboard to Power BI.
This is how I it set up.
No worries you will get there step by step~
If i'm using a very simple flat table like this below, create one Measure as in previous message.
for the setup i'd suggest using the Measure for 'Value', Time for Trend.
I did the measure and set it as the value, I dont have a time date for the trend, this sheet is sent out each month for the current month. So its set up like Payment Number | Amount | Goal Amount| Specialist Combo
