Hello,
I have a dimension field with values '1' and '2' and I set this field to single selection. I would like to use this field as a filter but have the values changed to another name. However with single select, the value automatically appears in the filter pane with the original values. How do I change the values in the filter to show different names?
Thanks
Hi @mpalha, I think it will be better if you have another field with the values you want to show:
If(Field=1, 'Text1', If(Field=2, 'Text2')) as AnotherField
Hi @mpalha, I think it will be better if you have another field with the values you want to show:
If(Field=1, 'Text1', If(Field=2, 'Text2')) as AnotherField