Forum Discussion
Trying to dynamically switch fields in a table
How do you switch fields in a table visual if you want different fields to appear?
I created a slicer and tried to create a DAX switch that would change the fields in the table visual.
but using selectedvalue() i was unable to switch out the fields, depending on the choice because switch changes measurers
How do i create something similar to a switch() where depending on the user choice, i switch from one field to the other?
Ex.
3 Replies
Your best bet for switching categorical fields is to use bookmarks and have each view the user can pick tied to a different bookmark.
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-bookmarks?tabs=powerbi-desktop
It has very little effect on overhead and I don't think there is a documented maxumim. This blog might help also.
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
