cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Hiding the table till selections are made

I have a table that looks as follows:

 

Learning_Hide 1.PNG

 

I would make a table of the above in Power BI and add about 4 slicers to the page.

 

However, I need the table created to show the data accordingle only when ALL slicers have selections. If all the 4 slicers do not have any selections, then the table returns blank. Is there a way to acheive this?

 

Alternatively, would also like to know how to do: Show table when atleast one of the slicers is selected.

 

Thanks!

2 REPLIES 2
Cmcmahan
Resident Rockstar
Resident Rockstar

If you don't like the workaround above for hiding/showing the visual, and want to show the table structure but with no data, you can set up a measure for each field you're displaying in your table like this:

ShowNameIfSliced = IF(
    ISFILTERED(Table[Slicer1 Col]) && 
    ISFILTERED(Table[Slicer2 Col]) &&
    ISFILTERED(Table[Slicer3 Col]) && 
    ISFILTERED(Table[Slicer4 Col]),
    Table[Name], BLANK()
) 

And using these measures instead of the raw values for your visualization. Similar results can be achieved with HASONEVALUE or other functions if ISFILTERED isn't giving you the outcome you prefer.

Cmcmahan
Resident Rockstar
Resident Rockstar

Unfortunately, there's not a way to dynamically show/hide a visualization easily in PowerBI.  There are a multitude of suggestions for this feature you can vote on for future improvements to PowerBI.  Here are a few.

There are some common workarounds for this issue. I like to use the method described here: https://exceleratorbi.com.au/show-or-hide-a-power-bi-visual-based-on-selection/

Your Make Transparent measure would be more complex than the one in his example, since you need to check if 4 slicers have a selection instead of just one, but it will give you a head start on getting the job done. 

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.