Show/Hide Table visual with slicer

[ls784]

Hello,

I have some sample data structure below (My real data is very large with lots of columns and rows).

What I would like to do is use a slicer or field parameter to hide/show each table visual depending on which one is selected on a slicer. I plan to have them fully overlapping so I would need the headers to completely disappear too. I am aware I can do this with bookmarks however I really wanted to see if there was any other way of achieving the same effect?

I have tried using field parameters to just hide certain columns depending on the selection but I think because the two tables don't have a direct relationship I couldn't get anything to work.

Any help would be really appreciated!

Many thanks,

[KarinSzilagyi · Accepted solution]

You can't fully hide the table (Power Bi sadly doesn't offer any visible true/false switches) but you could fully replace the content of your tables via the Field-parameters:

In this case I added (nearly) all columns of "FactTable" and "FactSales" into a field-parameter and added an additional column to categorize them as "Table A" or "Table B" for the slicer. 

This works for unrelated tables too

[ls784]

Amazing! I've spent all day on this and turns out all I was missing was that column to categorise them.
Thank you so much.

[KarinSzilagyi]

@ls784 You're welcome! Field parameters became my favorite toy in Power Bi, once I learned how to add columns to them 😅

[KarinSzilagyi]

Just to clarify: I mean it doesn't offer any dynamic visible true/false switches in the visual settings to show/hide whole visuals via measures.