Hide data in power bi table visual until a filters in slicers was selected.

[Ayoubid]

hello all,

please i would like to have some help with my use case, actually know if what i want to do is possible.

i want to hide the content of table until values was selected in 2 slicers "date range" and "phone number" in order to perform an export to csv file in matrix vizual, the user mustn't have the visibillity to all data.

[Sahir_Maharaj · Accepted solution]

Hello @Ayoubid,

you can achieve this by creating a DAX measure that will hide data in your Power BI table visual until both slicers are selected:

ShowData = 
VAR DateSelected = ISFILTERED('DateTable'[Date])
VAR PhoneSelected = ISFILTERED('PhoneTable'[PhoneNumber])
RETURN 
IF(DateSelected && PhoneSelected, 1, BLANK())

[v-denglli-msft · Accepted solution]

Thanks for the reply from Sahir_Maharaj, please allow me to provide another insight.
Hi @Ayoubid ,

I'm not sure how your dataset is designed, here is my sample.

The test data is as follows.

Create the following measure to check the slicer selection.

SlicerCheck = 
VAR dateSlicer = CALCULATE(SELECTEDVALUE('Table'[Date]),ALLSELECTED('Table'[Date]))
VAR phoneSlicer = CALCULATE(SELECTEDVALUE('Table'[PhoneNumber]),ALLSELECTED('Table'[PhoneNumber]))
RETURN
IF(dateSlicer <> BLANK() && phoneSlicer <> BLANK(),1,0)

Add this measure to the filter pane of the matrix, set to is 1. And lock this filter to prevent other users from changing it.

The final results are as follows. Hopefully it will meet your needs.

Please see the attached pbix for reference.

Best Regards,
Dengliang Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Sahir_Maharaj · Accepted solution]

Hello @Ayoubid,

you can achieve this by creating a DAX measure that will hide data in your Power BI table visual until both slicers are selected:

ShowData = 
VAR DateSelected = ISFILTERED('DateTable'[Date])
VAR PhoneSelected = ISFILTERED('PhoneTable'[PhoneNumber])
RETURN 
IF(DateSelected && PhoneSelected, 1, BLANK())

[ahmedoye]

Hi, can provide more information on this?

What you are saying for example is, you don't want the Matrix visual to display anything at all. Until when the user selects something in both slicers? Which means, if nothing is selected, the Matrix visual should technically be hidden?