Forum Discussion
muhammedswaliha
4 months agoRegular Visitor
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 → Pla...
- 4 months ago
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
danextian
4 months agoSuper User