Thanks db, worked like a charm!
As a side note, is there a way to format dimensions in a combo box? We have combo boxes in dashboards that allow users to filter by entity, it would be of great use if we can highlight in bold selections that are consolidations, i.e. European entities consolidated. These consolidation entities contain the prefix 'E_'.
I don't believe there is a way to format individual items within the list of values that are displayed in the combo box. The formatting parameters would apply to the entire combo box.
However, you could do some visual indentation as a potential method for achieving your desired result. Reference post here: Question: Can I create a dashboard dropdown or list box which contains a representation of a hierarc...
This is definitely on the advanced side. It takes advantage of Bound List parameters which can have a Display value be a unique/arbitrary representation of the selection while returning the MemberName for consumption by the result of the dashboard components.