What are you trying to accomplish? Do you want to filter the map on Order-IDs? If yes, then what Order Ids-All order`s or any specific condition?
It would be helpful if you can describe this a bit!
I am filtering the map by the state that the Order ID matches. So enter Order ID into parameter > order was in NY > filter map to NY only. I've accomplished this with the above noted formula, but I need a way for state to remain unfiltered when no order ID is present in the parameter. Hope that was more clear. Thanks!
ok! I think so you can do this without a parameter!
Just have OrderID as a quick filter instead of a parameter. The main part is having your Order-Ids on the map on Postal Code and State so that you can go back and forth as per your filter selection.
To make it better create a dual axis map so that it will also show the state.
clearing the filter will give you the whole map as desired.
refer the attached workbook.
Hi, thank you for the idea, but I need this to work with the parameter. Sorry I did not mention that. I will edit my first post.