Forum Discussion
Advocate IDisplay Number, only Number, and nothing but Number
Add a measure that is just SUM(Score), I called mine Curr Score. Then use Curr Score as the indicator, score as the trend axis and goal as the target goal value...
Microsoft EmployeeIf I put Score in a card and select a location via a slicer, it shows the result (7.1) no problem.
As for a KPI, the preloaded KPI visual doesn't seem to do the trick, but the custom visual here: https://app.powerbi.com/visuals/show/KPIStatusWithHistory1446562283967 doesn't need a trend value and shows exactly what you are describing (no exclamation point, but visual indicator - red orange yellow green - and the variance)
The only caveat is that if no slicer is selected, then it will aggregate the scores. I tried creating a measure:
Scores = IF(HASONEFILTER(Table1[Location]),VALUES(Table1[Score]),BLANK())
to return a blank if no slicer is selected, but the KPI just shows red with -100% so that won't work either.
Resolver IIIAdd a measure that is just SUM(Score), I called mine Curr Score. Then use Curr Score as the indicator, score as the trend axis and goal as the target goal value...