Forum Discussion
Toggle Value Categories
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.
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/
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.
5 Replies
What's wrong with using switch?
- 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.
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/