Display custom field instead of "ALL" when select all

Question & Answer
, ,
1

Hello,

when I “Select All” in my Control list for Geo Country, it displays automatically ‘All’ in my titles linked to the parameter ‘GeoCountry’.

Is there a way to customize this without using a formula in my title? To display ‘EU’ instead of ‘Select All’ in the Control list as well as in my titles thus?

Thank you.
Sarah

image
image1218×451 50.9 KB

2

First I would edit that GeoCountry to have a static default of EU. Then get rid of the select all option in the control.

After that I would make a calculated field to filter your visuals.

filter_field = ifelse(${Country}=‘EU’,1,${Country}={Country},1,0)

Then have your visuals have a filter of filter_field equal to 1. That should get the job done!

Oh and at the end add the GeoCountry parameter to your title!

1 Like
3

Hi @SarahV. Did Max’s solution help? I am marking his reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Q&A Forum!

4

Thank you very much for your support Max. It is now resolved

1 Like
5

Thanks @Max! :slight_smile: And thanks for letting us know @SarahV!