Slicer Issue: Filtering Fault Types by Specific Problem

[Anonymous]

Hello everyone, I need help with an issue. I have a table containing different problems, and in one of the columns, I have the fault types associated with each problem. This column displays all the variants of fault types for each problem.

My goal is to use a slicer to filter the fault types in my report. However, the problem is that when I do this, all available variants in the column are displayed.

What I'm looking for is that, for example, when selecting the "Mechanical Problem" option in the slicer, it displays all the problems that have "Mechanical Problem" as the fault type. However, when I attempt this, the slicer shows me all the options present in the column.

I even created independent columns with DAX to quantify the fault types, as shown in the ss,

but I haven't been able to find a way to group the fault types in a slicer. I tried creating a new measure, but I haven't found the solution. I'm relatively new to using Power BI, so I would greatly appreciate your support.

[Anonymous · Accepted solution]

Hi @Anonymous ,

I create a sample for you, please refer the attached .pbix file.

Table:

Table2:

create a mesure with below dax formula:

Measure =
VAR _a =
    SELECTEDVALUE ( 'Table 2'[Column1] )
VAR _b =
    SELECTEDVALUE ( 'Table'[Column1] )
RETURN
    IF ( CONTAINSSTRING ( _b, _a ), 1 )

Add a sclicer with Table2 field, add a table visual with Table field, then add the measure to the table visual filter pane and set

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.