Forum Discussion

longlongisi's avatar
longlongisi
Frequent Visitor
2 years ago
Solved

visual filter with measure not working

hi,

i have added a measure filter to the Table visual. I would like not to display the values of table visual if the slicer is not selected.

filtercheck = INT(isfiltered('Product'[BCP])). However, it doesn't work. I do add a card to test the measure , it works properly. Can anyone help?

 

 

Need Help
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    Hi longlongisi 
    It is happening because you are using the same column from the same table in a slicer and in the visual.
    Once you put it on the table the indicator of the filter checking will be true, because this table is filtered by the context of the column.
    To get the wanted effect, you need to use the product Product'[BCP] in the slicer and formula,
    but on visual to put the column from the fact or other table.
    I prepared a small example  to show how it works:

    the flag formula is based slicer table:

    flag = if(ISFILTERED('slicer table'[category]),1,0)
    But on the visual, I put a category from the other table:

     

    result in nothing selected :

    and after slicer selections:

    The pbix is attached, you can follow the steps.

     

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

     

2 Replies

  • Ritaf1983's avatar
    Ritaf1983
    Icon for Super User rankSuper User
    2 years ago

    Hi longlongisi 
    It is happening because you are using the same column from the same table in a slicer and in the visual.
    Once you put it on the table the indicator of the filter checking will be true, because this table is filtered by the context of the column.
    To get the wanted effect, you need to use the product Product'[BCP] in the slicer and formula,
    but on visual to put the column from the fact or other table.
    I prepared a small example  to show how it works:

    the flag formula is based slicer table:

    flag = if(ISFILTERED('slicer table'[category]),1,0)
    But on the visual, I put a category from the other table:

     

    result in nothing selected :

    and after slicer selections:

    The pbix is attached, you can follow the steps.

     

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