Forum Discussion

Italian8's avatar
Italian8
Frequent Visitor
4 years ago
Solved

1 Date Slider for filter/Show data points that fall within Date Range

I have a table in Power BI with Multiple Columns. In each of the columns is a different range of dates. Is it possible to create 1 slider that will apply to all 15 of the columns full of dates and only the dates will appear within the input range and the others will be blank? Preview of my table is show below

  • Anonymous's avatar
    Anonymous
    4 years ago

    HI Italian8,

    AFAIK, the current default slicer feature does not support these operations, you can't use one slicer to directly filter on multiple fields.
    Perhaps you can create an unconnected table as the source of the slicer, then write a measure expression to use on the 'visual level filter' to filter on table visual records.

    Filtering a measure in DAX Studio - SQLBI

    Regards,

    Xiaoxin Sheng

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    HI Italian8,

    AFAIK, the current default slicer feature does not support these operations, you can't use one slicer to directly filter on multiple fields.
    Perhaps you can create an unconnected table as the source of the slicer, then write a measure expression to use on the 'visual level filter' to filter on table visual records.

    Filtering a measure in DAX Studio - SQLBI

    Regards,

    Xiaoxin Sheng