Can I define a label for certain filter values
Is it possible to use the custom query option in a filter to define some sort of label to show in the filter. So I want to filter on a number but show a label. This label is in a different table. I can easily create a query with gives the number and the label (description) but the measure table has the number in it and not the label.
I thought I read somewhere that this is possible but I get an error that the query should result in a single field.
Maybe the names should be something specific.
I tried finding the article or forum post where I read that this was possible so now I am unsure if it is.
Please let me know.