Using Column Names as Slicer Option

Create a Disconnected Table for Column Selection

In Power BI, go to Modeling > New Table and create this:

MissingColumns =

DATATABLE(

    "ColumnName", STRING,

    {

        { "Make" },

        { "Model" },

        { "Year" },

        { "Mileage" }

    }

)

This will be the source for your slicer.

Create a DAX Measure to Check If a Row Has "Missing" in a Selected Column

Add this measure to your model:

ShowRow =

VAR SelectedColumns = VALUES(MissingColumns[ColumnName])

VAR IsMakeMissing = "Make" IN SelectedColumns && SELECTEDVALUE(Cars[Make]) = "missing"

VAR IsModelMissing = "Model" IN SelectedColumns && SELECTEDVALUE(Cars[Model]) = "missing"

VAR IsYearMissing = "Year" IN SelectedColumns && SELECTEDVALUE(Cars[Year]) = "missing"

VAR IsMileageMissing = "Mileage" IN SelectedColumns && SELECTEDVALUE(Cars[Mileage]) = "missing"

RETURN

IF(IsMakeMissing || IsModelMissing || IsYearMissing || IsMileageMissing, 1, 0)

3. Apply a Visual-Level Filter on the Table Visual

Now add a table visual to show your Cars data.

Then:

• Drag the ShowRow measure into the visual’s Filters pane
• Set filter to ShowRow = 1

Now You Can:

• Use a slicer on MissingColumns[ColumnName]
• Select one or more column names (like "Model" and "Mileage")
• The table will dynamically show rows where either column has the value "missing"