Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Help with filters

Good afternoon. I have a small problem and a challenge for some of you.     I have 2 tables, "Calendar" and "Table1". Within the table calendar I have a column formulated with a range of dates and...
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi Anonymous,

     

    First, text column is impossible to use slicer to achieve 'before' or 'after' filter mode. I'd like to suggest you to use date value or numeric value to instead.

     

    Second, power bi use 'and logic' to link slicers, if you have multiple slicers with same source column, it is impossible to get different selection items from different slicers.

     

    AFAIK, you can use measure as filter tag to control which item displayed in visual. Unfortunately, it not works on slicer. (visual level filter of slicer is been disabled,if you apply on page level, it will also affect other visuals)

     

    Regards,

    Xiaoxin Sheng