Forum Discussion

marcelodiazm16's avatar
marcelodiazm16
New Member
2 years ago
Solved

Filters with no data

Hello! I have a problem, i have two filters (month and year) and the data im working on starts from june 2023 until february 2024 (now), so i don't want to show, for example, the months with no data ...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi marcelodiazm16 

     

    Unfortunately, it's not support to dynamically change the field of the filter.

    But maybe you can try this:

    I create a set of sample data:

    It is easy to see that the value of Jan, Feb, Mar is empty.

    Then Create a calculate column:

    Month = IF(
            ISBLANK('Table'[value]),
            BLANK(),
            MONTH('Table'[date])
        )

    Then create a Slicer:

    The result is as follow:

     

    Best Regards,

    Zhengdong Xu

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