master dimension as pick list

[Anonymous]

The data I have is a bit of an ugly duck.

I have created master dimensions a set of about 20 "groups" of products. Now I want to add these "groups" as a drop down click "Filter box"

How can I do this?

If I try to use a "Filter Panel" it just creates a set of "boxes" that scale out into "..."

Normally if this were in a table and linked this would be simple, but the master item can only be built by formula based on formula.

[Lisa_P · Accepted solution]

Can you create a table in your data model that has the dimension labels in one field and the expressions to create them in another field in the table.

You can then select the Field name for the Dimensions in a filter pane and select from there.

[Anonymous]

Would this have to be populated in data editor.

Do you have any links to examples.

I understand concept, just would help to see example.