Forum Discussion

rodriperez10's avatar
rodriperez10
Regular Visitor
5 years ago
Solved

Hiding table before filtering

Hello,

 

I´m having a problem that I can´t seem to figure out. I´ve created a measure to help me hide tables when no "row" of a table has been selected which looks like this:

 

SGs Filtrados =
IF(
ISFILTERED(v_sup_supplier_family_dwe_tecp),1,0
)
 
The measure does it job perfectly, however the data in the table is not hiding and I don´t understand why:

 

As you see the value of the measure is 0, but the table is still showing data.

 

Does anybody knows how to solve it?

Thanks


 

Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    5 years ago

    Hi， rodriperez10 

     

    According to your description, I think you used the wrong function. The isfiltered() function returns TRUE when columnName is being filtered directly. It is generally used to judge whether the data in the slicer has been selected. It doesn't filter the data of the row. 

    You can create a measure based on the row data you want to filter,Like this:

    SGs Filtrados =
IF ( table[column] <> BLANK (), 1, 0 )

    If you still have problems, please feel free to ask me.

     

    Best Regards

    Janey Guo

     

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

1 Reply

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Community Support
    5 years ago

    Hi， rodriperez10 

     

    According to your description, I think you used the wrong function. The isfiltered() function returns TRUE when columnName is being filtered directly. It is generally used to judge whether the data in the slicer has been selected. It doesn't filter the data of the row. 

    You can create a measure based on the row data you want to filter,Like this:

    SGs Filtrados =
IF ( table[column] <> BLANK (), 1, 0 )

    If you still have problems, please feel free to ask me.

     

    Best Regards

    Janey Guo

     

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