If I am understanding correctly, you should be able to do a Boolean statement for your color field and your parameter field. Something like this perhaps:
I have a feeling though that I am not completely understanding the problem. Are you able to attach a sample workbook?
good morning Cameron
as you know Parameter don't do anything unless backed up by a formula or filter - you have already used contains with a parameter
You can split the value in the parameter (in your case color - for me it was category)
see the superstore example with state and category
then split the category from the parameter value
then use it in a filter
it returns this
all states are showing (could be filtered out separately) but only furniture
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
split filter.twbx 2.4 MB
Thank you for the ideas. I ended up using a VERY long If then statement. I'll put an example of it below.
IF CONTAINS([Color],'White')Then "White"
elseif CONTAINS([Color],'Black')Then "Black"
elseif CONTAINS([Color],'Blue')Then "Blue"
elseif CONTAINS([Color)],'Green')Then "Green"
elseif CONTAINS([Color]),'Yellow')Then "Yellow"
Else "No Color"
Thank you again!