Toggle Value Categories

[Rick528]

Hi, theoretical question about toggling visuals.  Assume I have two maps.  On the first map, the bubbles are sized by (i) number of employees per location.  On the second map, the bubbles are sized by (ii) annual budget per location. Everything else is the exact same.   Is there a simple way to toggle between (i) and (ii) using the same map?  Or, do I need to provide two maps?  Trying to cut down number of visuals on a dashboard.

Coming from Excel and PowerPivot where this is very easy to do.  Have no idea how to do it in PBI without using switch.   

[MattAllington · Accepted solution]

So no you are not missing anything.  Switch is pretty easy.

I wrote an article on another topic here, but the concept is the same as what you need. 

https://exceleratorbi.com.au/measures-on-rows-here-is-how-i-did-it/ 

[MattAllington]

What's wrong with using switch?

[Rick528]

Hi Matt, thanks for your reply. Nothing is wrong with switch. It's just that I haven't used it before and I don't mind diving in but wanted to make sure I'm not missing an obvious function.

[MattAllington · Accepted solution]

So no you are not missing anything.  Switch is pretty easy.

I wrote an article on another topic here, but the concept is the same as what you need. 

https://exceleratorbi.com.au/measures-on-rows-here-is-how-i-did-it/ 

[Rick528 · Accepted solution]

Hi Matt.  Thanks for the answer.   I figured it out and implemented.  It slowed the model down considerably.  Not sure why.  Strange becuase just three simple measures are switched ...

Anyway, it works, so will use it.  

[MattAllington]

My understanding is this is a known "problem".  When you use switch, you are really just using IF, and IF evaluates each option fully even though it only uses one of them.  So it should take 3 times longer with 3 options.  However the fact that this is perceptible probably means that there model is inefficient in some other way.