Forum Discussion
Slicer For Material Criteria From Different Columns
Hi All. Hoping I can get some help here. I've looked at different Q&A's for issues like mine but just don't seem to see any answers. I have Material codes that can fall into different categories. I created column names in my table for a 'Y' or 'N' which shows the categories the Material can be in. I need to allow the user to select a category and if that Material is in that category, have it show up in the table. I also need to have the user Select another category and have that same material show in that category as well if it is part of it.
So you see below, the first material code 048E01L0000 should show up in my matrix table with the IsFillAssembly group or the IsSupplyCommitGroup or the IsSkincareSupplyCommit group or IsTubes group (Anyplace where there is a 'Y' value.). I need to somehow get a slicer to allow me to do it. I want the user to select a category and the materials that are 'Y' in that category will show in the table matrix. Any help is greatly appreciated! Thanks
13 Replies
darentengmfsPost Prodigy
Hi Anonymous
You might want to create new columns for this.
InFillAssembly_Exist = IF('Table'[InFillAssembly] = "Y",'Table'[Material],"")
This will fill the new column with Y's into the Material number, and N's with blanks.
On the other hand, you can unpivot the columns. Go to Power Query Editor, select all columns EXCEPT for Material, go to Transform tab, and select Unpivot columns. You will get something like this. Then, filter out all the "n", apply the changes, and use Attribute as your slicer.
- darentengmfs
Hi Anonymous
It will, but I believe since there will only be 2-3 columns left, it will not take a very long time to load. Loading time depends on both rows and columns.