Use slicer to a filter table based on values in multiple columns

Question

I am very new to Power BI and DAX in general so please&nbsp;forgive me:&nbsp;So the context of the story is:I have conducted a survey where there were&nbsp;questions with free textI've then created a table of "themes" where it's simply a single list of themes that each comment would be categorised byI have then created 3 separate category columns for each question's response where up to 3 Themes can be&nbsp;allocated to each response, (all the values&nbsp;are based on the values in the Themes table mentioned above)I have then created a Table visualisation where the&nbsp;Response, Category 1, Category 2, Category 3 are all represented (all of these are from the same table)I&nbsp;have then created a Slicer visualisation with the column out of the List of Themes table is put in it that has the unique list of themes to filter on.But now, when I select a Theme on the Slicer, it only seems to filter&nbsp;based on Category 1 and completely ignore the rest of the rows where the selected Theme was in Category 2 or 3.TABLE COMMENTS&nbsp;Response Comment&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Category 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Category 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Category 3This is a random response 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; x&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; y&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; zThis is a random response 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; x&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; y&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;nullThis is a random response 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; x&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; z&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;nullThis is a random response 4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; z&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;x&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; y&nbsp;TABLE&nbsp;THEMESCategoryxyz&nbsp;The&nbsp;result i'm expecting is, when I select&nbsp;Theme X from Slicer, I need to see all rows&nbsp;from the top table. Right now I can only see the responses 1,2 and 3.&nbsp;Don't forget that this is the scenario for just 1 question and i need to replicate it for 3 questions in total (i don't want them to be together).&nbsp;I&nbsp;can't use the unpivot function as there are relationships between the "Response Comment" and other tables that won't allow it to have duplicate values in that column after you unpivot.&nbsp;Any help would be appreciated.&nbsp;

v-chuncz-msft · Accepted Answer

Anonymous,
&nbsp;
Make the relationship inactive between these two tables and add measure below. It takes advantage of&nbsp;Show Categories With No Data.
Measure =
VAR t =
    VALUES ( THEMES[Category] )
RETURN
    IF (
        COUNTROWS (
            FILTER (
                COMMENTS,
                COMMENTS[Category 1] IN t
                    || COMMENTS[Category 2] IN t
                    || COMMENTS[Category 3] IN t
            )
        )
            &gt; 0,
        1
    )

Forum Discussion

Use slicer to a filter table based on values in multiple columns

1 Reply

Related content

Parameter slicer with measure for multiple columns

Single Slicer to Filter Multiple Columns

Slicer for filtering several columns

Once Slicer for multiple columns

Sequential Order column based on multiple criteria