Forum Discussion

MackAttack26's avatar
MackAttack26
New Member
2 years ago
Solved

Multicolumn Slicer for Table Filtering

I have the following set of data. The data table as a column that has concatenated all of the column names that have a TRUE value for the record. Data Table data_col tf_col_1 tf_col_2 tf_col_...
DAX
Filter
measure
Slicer
Table
  • Anonymous's avatar
    Anonymous
    2 years ago

    I have one way out.

     

    First replace the value false with null and change the columns type to true/false.

    Create separate dax for each tf column

     

    Make parameter with those dax

    In the slicer you need to select parameter as well as in the table you need to select parameter
    and you will get your desired "True" rows

     

    If this meets your requirement then pls accept the same as the solution.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

I have one way out.

 

First replace the value false with null and change the columns type to true/false.

Create separate dax for each tf column

 

Make parameter with those dax

In the slicer you need to select parameter as well as in the table you need to select parameter
and you will get your desired "True" rows

 

If this meets your requirement then pls accept the same as the solution.