Hide data in a table until an option has been chosen in a slicer

[jonclay]

Hi everyone

My report contains various slicers that update a table containing contacts on another tab depending on what options are chosen in the slicers. One of the slicers contains communication preferences which is vital for GDPR here in the UK.

Our problem is that users could potentially forget to choose an option on the Communication Preference slicer and therefore the data in the table on the other tab could include contacts who have not agreed to receive a certain type of mailing.

My initial thought was to find a way to disable data export from the table unless an option has been chosen in the Communication Preference slicer, but I now know that this is not possible.

Is it possible to "hide" the data in the table (for example by making the text white on a white background) until an option has been chosen in the Communication Preference slicer? Of course, I'm open to any other methods too!

Many thanks
Jon

[jonclay]

Thank you so much @amitchandak . That works perfectly.

I watch all their videos, but had somehow missed that crucial video!

[amitchandak · Accepted solution]

@jonclay , Refer the video from Guyinacube on the same topic

https://www.youtube.com/watch?v=sXn-QZqLD-8