HIDE TABLE UNTIL MULTIPLE FILTERS SELECTED AND CARD BLANK

[AnassEss]

Hi guys,

I could solve some problems at my power BI Desktop exercice but I still have 2 problems:

1. I need to hide a table where we have 3 filters: 3 slicers (CLIENTS, Type and device) I can hide the table when it comes to client or type slicer but whenever I put Device in the condition the meassure never works. Tried this query: 

ShowColumn =

IF(

    HASONEFILTER(BBDD[Client]) || HASONEFILTER(BBDD[Type]),

    2,

    1

)

So in this query, we get the number 1 when we don't filter and nº 2 when we filter by this columns (with this I can hide or show table). The problem comes when I add HASONEFILTER(BBDD[Device]), in this case the other 2 conditions work and show nº 2 but filter by device shows 1(similar to the case where we don't filter by anything).

2. I got a card with the name of clients (name changes every time i select slicers and works correctly). I would like it to be blank until i select a filter. For some reason every time I make a measure and put it to the card it doesn't work(can't even put the measure to check what happens).

If anyone has some insights I would appreciate it

Thanks in advance and Kind Regards.

[Idrissshatila]

Hello @AnassEss ,

check this out https://youtu.be/O5k8iud_Mcw?si=WSOk8aT9kOMFUy7H

[AnassEss]

I appreciate it and the video is really useful but not in this case since I don't want to hide the whole thing and it is not based on a slicer such as hide and show, it is based on multiple slicers that are interconected. Any suggestions for nº 2 problem?