Forum Discussion
How to Switch Between Multiple Full Tables (Different Structures) Using a Dropdown Slicer + One Butt
I have multiple tables on one page. Each table shows different stats and has a completely different column structure. For example:
· Most Runs → Player, Runs, Inns, Avg, SR
· Highest Score → Player, Score, BF, 4s, 6s, Venue, Date
· Best SR → Player, SR, Runs, BF
· Most Sixes → Player, Sixes, Runs, BF
· Partnership Runs → Partners, Runs, Wicket, Match
· Most Ducks → Player, Ducks, Inns
---
What I Want:
A dropdown slicer (using a disconnected table) where the user selects a table name, and a single button next to it. When the user clicks the button, the correct table should appear — based on the slicer selection.
I want one button, not multiple buttons for each table.
---
What I Tried:
· Bookmarks work, but require multiple buttons
· Field parameters switch columns, not entire tables with different structures
· Conditional visibility (fx) is missing in my version (no Selection section for Table visuals)
· Dynamic bookmark using measure + button Action → Bookmark → fx is also missing
---
My Power BI Version:
· Release: February 2026
· Version: 2.151.1182.0
· fx button next to Bookmark is not visible
---
My Question:
Is it possible to achieve this in my current Power BI version? If yes, how? If not, what is the cleanest alternative to keep the design simple (one dropdown + one button)?
Thank you.
You can do this with a bit of a tweak to field parameters. First create a field parameter which includes all the columns and measures you want to include across all configurations. Then add a new column to the field parameter table by editing the DAX, and assign each column or measure to a category, e.g. "Most Runs", Most Ducks". Rename the column to Category, not Value4.
You can have the same column in multiple categories by repeating the line for that column / measure with a different ordinal and category.
Put the field parameter into a table visual, and add a slicer using the category field. Changing the slicer selection changes the columns shown in the visual.
You can see an example below
4 Replies
You can do this with a bit of a tweak to field parameters. First create a field parameter which includes all the columns and measures you want to include across all configurations. Then add a new column to the field parameter table by editing the DAX, and assign each column or measure to a category, e.g. "Most Runs", Most Ducks". Rename the column to Category, not Value4.
You can have the same column in multiple categories by repeating the line for that column / measure with a different ordinal and category.
Put the field parameter into a table visual, and add a slicer using the category field. Changing the slicer selection changes the columns shown in the visual.
You can see an example below
Hi johnt75,
Thank you so much! I've been trying to solve this for days, and your solution finally worked perfectly.
The dropdown slicer now switches between tables correctly. However, I have one small issue:
When I select "Most Runs" in the slicer, I want the table to be sorted by Runs descending (highest runs first). But currently, it always shows in Player name order.
How can I make the table default to sorting by Runs descending for the "Most Runs" category?
Thanks again for your help.
I think that you can leave Player out of the field parameter, and just add it to the visual on its own, along with the field parameter. Adjust the Parameter Order value in the field parameter table so that the value you want to sort by is always in the first position within its category, and then sort the table / matrix visual by the first column in descending order. When you switch to another category I think it will still be sorted by whatever value is now in the first position.
