Data for Page Level Filter from multiple columns

[Ashwini81]

I have a table which gives information like OS and RAM Size about computers and also Tags associated with that computer.

ComputeName	OS	RAM	Tags
Comp1	Windows	16GB	Team1, Team2
Comp2	Linux	8GB	Team2
Comp3	MAC	16GB	Team1, Team2,Team3
Comp4	Windows	8GB	Team3, Team1
Comp5	MAC	8GB	Team2, Team3
Comp6	MAC	16GB	Team3
Comp7	Windows	16GB	Team1
Comp8	Linux	16GB	Team1, Team2, Team3
Comp9	MAC	16GB	Team1, Team2
Comp10	Windows	8GB	Team2

In my Power BI report there needs to be a page level filter which will be applied to all the visuals in the page. Eg: The filter should have the following data Team1, Team2, Team 3 and on choosing a particular Tag, the computer information regarding that Team should be shown in the report page.

I split the Tags column using the 'split column' option. Now I am not able to show the Tags from the 3 columns in a fpage level filter and filter the visuals based on the option chosen. 
Any help with this is appreciated.

[Ashwini81]

I created a new table by taking distinct values from the columns which I got after splitting. This new table had 1 column. However i could not create relationship from this newly created table column to the 3 columns of my original table as only one relation can be active. The filter should be able to filter from all the 3 columns..

Here is the Power BI Report TagsReport 

[v-chenwuz-msft · Accepted solution]

Hi @Ashwini81 ,

I recommand you to use "unpivot columns" to do that.

Add one step to the power query

= Table.UnpivotOtherColumns(#"Changed Type2", {"ComputeName", "OS", "RAM", "Tags"}, "Attribute", "Value")

Pbix in the end you can refer.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ashwini81]

Hello,

I was able to solve this by adding an Index column and then unpivoting the column as mentioned. Thanks for the help. The same solution is explained in the following post

Filtering and slicing either a multivalued column ... - Microsoft Power BI Community

[Anonymous]

Hi,

Unfortunately I cannot see the attached pbix-file. I think one way to solve this issue is by:
1. As you said, split the column,

2. Make a separate table with a column of all the team names
3. Create a relationship between the two tables
4. Use the newly created table as filter