Forum Discussion
Filters with no data
- Anonymous2 years ago
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.
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.