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 c...
darentengmfs
Post Prodigy
Post ProdigyHi 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.
- Hi, If I unpivot then wont that create more records in my table (which is big)?
- 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.
- Hi darentengmfs, Actually I have about 35 columns and over 200,000 records at this time, and the record count builds everyday.