paramCountry - multiple values allowed
paramCurrency - single value - SGD or Local
Vertical bar chart - x-axis is Country, value is Sales (calculated field which can point to Sales SGD or Sales Local)
To use the same Vertical bar chart for both SGD or Local currency with the below check:
If currency is SGD (common), multiple country selection is allowed.
If currency is Local, only single country selection is allowed.
How to do that in QuickSight?
@lbl, you could try creating 2 filters/parameters instead of the singe one (paramCountry). One of them should allow multiselection, another one should not. You can show/hide and turn on/off the filters when the paramCurrency value is changed. You should use free-form for this.
If free-form is not an option for you, you can use this approach (with minor improvements) How can I select multiple lines from a table? (and how could I then DESELECT those items to exclude them form the analysis?) . But keep in mind that this approach it’s a little bit more complex.
@hrolol I am using Free-form. Above are the 2 filters on respective parameters. There is no setting to show/hide and turn on/off filters. Please advise. Thanks!
@Hrolol Yes, Rules is available once filter control moves to inside the sheet. BUT I am sharing the filter control across sheets, hence it makes more sense to place it on top. Any reason Rules only available when inside the sheet and not top of sheet?
Free-form sheets allow to hide/show show visuals and use some other features. If an visual is not placed on a free-form sheet, it can’t use these free-form specific features. So there are no reasons to move your controls inside a free-form sheet but the ability to hide them.
As mentioned, filtering control is meant to share across sheets. Any workaround or solution, please. Thanks!
You can move these filer controls to all these sheets. Actually, when you move a shared filter control inside sheets it remains a single control that appears in many sheets. For example, when you rename it, it changes the label in all sheets.
If you do not wat to make significant changes in the analysis you can create 2 analyses (one for SGD and one for Local ). You also can use links to switch between them smoothly and pass parameter values.
There are other ways to implement this but I believe they are more complex and require more efforts.
