Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

why is my visual ignoring filter

so i have this visual which is a multi-card, i put in a column sourced from a ssas tabular model, and then on filter i put in the result of a slicer that is either 1 or 0, i set the visual to only show items when value of the slicer is 1, but the visual just ignores the filter and show items any ways. i do this with another column but that column obeys the filter just fine, so my question is what is so special about this column that it ignores filter?

 

Need Help
Show and Tell

3 Replies

  • lance_6's avatar
    lance_6
    Icon for Helper II rankHelper II
    5 years ago

    This is difficult to answer without more context.

    What does the data look like?

    How were the columns created?

    What do the relationships look like?

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      this is all sourced from a tabular model in ssas. the relationship is complex, but can you give me just a few reason why this could happend and ill check on my end? also i like to add if i change the visual level filter to show items when measure is 0, then the visuals doest show anything when measure is 0, but also doesn't show anything when measure is 1, very strange.

  • v-lionel-msft's avatar
    v-lionel-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi Anonymous ,

     

    Do you mind providing the formula of the measure?

     

    Best regards,
    Lionel Chen

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