Forum Discussion
Solved
Filter Added new Column
I have a table with status Contractor, Staff, Vendor, Manager I need to create new column That it will show the name of the person who have manager status.
- You have only provided one sample table? Are there multiple tables or are all columns in one table? If all in the same table, you can just add [Name] to a slicer. Then you have the ability to add [Status] to the 'Filters on this Visual' without needing to put [Status] actually in the visual. Set that filter to basic and select 'Manager'
tebtim19 ,
Not Clear,
If you are looking to match the status with another table use Merge in Power Query or create a relationship on Status.
If you want to answer your question quickly, please pose question with proper deatils and if possible share sample data.
Regards,
Manikumar
Hi, okay this are the sample tables
Name | Status | Location | Gender |
Ana | Vendor | UK | Female |
Ben | Manager | UK | Male |
Jon | Staff | PHP | Male |
Kyra | Manager | UK | Female |
Linda | Staff | PHP | Female |
Gina | Manager | UAE | Female |
Porchia | Manager | PHP | Female |
Now I want to make another column which will give me the name of the status Manager which are
Ben |
Kyra |
Gina |
Prochia |
I need this column so I can eaily use this to create a slicer of option of managers
- You have only provided one sample table? Are there multiple tables or are all columns in one table? If all in the same table, you can just add [Name] to a slicer. Then you have the ability to add [Status] to the 'Filters on this Visual' without needing to put [Status] actually in the visual. Set that filter to basic and select 'Manager'