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 EmployeeAlso, thank you bblais for showing me something I never knew! I always thought the trend field of the KPI visual needed to be a date field. Never thought to dump something else in there (especially since you can turn off the trend axis).
Resolver IIIIf you have Locations and LocationScores tables, you can use the ScoreDate as the trend axis and it should use the "most recent" like this:
mhotekI have it working, although I have no idea what is going on. All it would do is throw an aggregate any time I tried to stick the score in the Indicator or the target goals. I had to do the following:
1. Go to the model
2. Double click the relationship
3. Change it to 1:1 and a cross filter direction to Both
4. Hit enter when it gave me the "cross filter direction is invalid" error message to force it to create it
5. Edit the relationship
6. Change it back to 1:Many with a cross filter direction of single
Now, my indicator just shows as the column, not Count of Score, Sum of Score, etc. The Target Goals just shows as the column instead of Count of Goal, Sum of Goal, etc.
I have no idea what editing, forcing a relationship creation, reediting to put it back the way it should be did to PowerBI, but it now works as I expect it to.
- mhotek
I actually obeys my Report, Page, and Visual filters now as well, no need for a slicer. Before, I hacked at the relationship between the two tables, it ignored any report, page, and visual filters.