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...
Advocate II 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.
Advocate II 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.