Remove blanks from dynamic slicer

Hi Silvard 

To dynamically filter out blank/empty values from a multi-selection slicer without modifying the data in Power Query, you can use a DAX measure and apply it as a visual-level filter. The measure checks whether the selected columns contain blank values and excludes them. For example, using SELECTEDVALUE() or ISBLANK() in a DAX measure can help detect blanks dynamically based on slicer selections. You then apply this measure as a filter in the filter pane, setting it to show only non-blank values. This ensures that as users select different fields in the slicer, the slicer automatically hides empty values while keeping the filtering flexible across multiple columns. This approach is efficient, does not require hardcoding column names, and works regardless of how many columns are included in filtering.