Datatable options

I think I understand what you want.

Easier for me to explain in a video.

https://www.youtube.com/watch?v=aQr76sGwFo4

Let me know if I've missed the point or you need further detail.

Hi StevenT ,

Thanks wardy912  and KNP Did you get a chance to try the solution that wardy912  suggested using Field Parameters?
That approach is indeed the correct and simplest way to dynamically switch the dimension (like Category or Region) in your matrix rows.

Once you’ve created the Field Parameter under Modeling - New Parameter - Fields, make sure to.

1. Add the generated parameter field to the Rows section of your matrix visual.
2. Create a slicer using the same parameter and set it to Button style (under Format → Slicer settings → Style → Tile).
3. Now, when you click a button (e.g., Category or Region), your matrix will automatically switch the row dimension accordingly.

This setup gives you exactly the button-style field switcher you were looking for.

Thanks,
Akhil.