Forum Discussion
Data for Page Level Filter from multiple columns
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.
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
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.
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