M Language: Access an element of a parameter list while filtering by text

Hi akhaliq7  please refer to the linked tutorial, it seems exactly what you need:

https://www.youtube.com/watch?v=gFqlfSckc5s

If this post helps, then please consider Accepting it as the solution to help the other

members find it more quickly

For my specific issue this can solved by using the or and creating more than one parameter, or in my case I created one parameter and hardcoded one value as that extra value was only to be used in one report,

= Table.SelectRows(#"Changed Type",each ([Department] = Department or [Department] = "Admin"))