Conditional Axis values based on filter

[Misca]

My dashboard is calculating contacts per sales team / sales person.

I'd like to be able to toggle the bar chart visuals from contacts per team to contacts per sales person depending on if the teams have been filtered or not. How could this be done?

I have a feeling it should be done with HASONEVALUE- and VALUES-functions but I just can't make it work.

 

[tallan]

Have you tried the drill down/drill up feature in Power BI visuals?

 

[Misca]

I have and it works. But I'd rather use the real filters because the drill down filters seem to forget all their settings whenever you change something else: If you're comparing things by the sales person and change the product, date or location filters the sales persons visual displays the teams again.