Forum Discussion
Show/Hide Table visual with slicer
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,
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
4 Replies
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
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.
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.ls784 You're welcome! Field parameters became my favorite toy in Power Bi, once I learned how to add columns to them 😅
