Forum Discussion
Using slicers with gauge visualisation
I've created a gauge chart which should show how much revenue a particular sales rep has pulled in in relation to their budget (target). I've uploaded two tables that look like this: Budget Table:...
it looks to me like your relationship arrow is pointing in the wrong direction.. if the slicer is on the company owner from company then the relationship should have the arrow point to the budget table not the other way around
For some reason, I don't seem to be able to change the direction of this relationship. I've tried dragging the company field to the budget table, and the budget field to the company table, but the arrow goes in the same direction either way. Is there a different way of doing it?
Also, if I wanted to add more connections between the two tables, such as sales team, would I add a second connection between the two tables, or just ensure an exact match between field names (e.g. [Company]team and [Budget Q]team)?