Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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:...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

 

Here is the relationship.

The slicer is in its own table (Company owner) which has a relationship with current_owner_name in the Company table.

Thanks for helping!

vanessafvg's avatar
vanessafvg
Community Champion
6 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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)?