Show or hide fields based on a parmater

[alon_kenett]

Hi,
I’m trying to build a QuickSight visualization where the displayed fields change dynamically based on a parameter or condition.

For example:

1. If I choose “Option 1” in the parameter control, I want to show Field A, Field B, and Field C. If I choose “Option 2,” I want to show Field D, Field E, and Field F.
2. Another case would be to show or hide a field dynamically based on a condition, such as when all the values in a field are NULL or meet a specific rule.

Is this functionality possible in QuickSight? If so, how can I achieve these use cases?

Thank you!

[lary_andr]

Hello @alon_kenett , Hope this message finds you well.

I Belive that what you want to do is similar to this solution:

Hide visual based on filters

I have a survey that I have run for two different teams. Team 1 does have 5 questions and while other one have 8 questions. I want to build one analysis for both teams so that it’s easy to manage. The challenge - Since I have put 8 visuals, when team 1 logs in they see 3 visual blocks with no data. What I want to achieve - When team 1 logs in, they see 5 visuals blocks and team 2 see 8 visuals blocks. Any guidance/hack to achieve this?

Please, tell me if it’s work or not, so I can help you better

[royyung]

you can refer to this example https://democentral.learnquicksight.online/#Dashboard-TipsAndTricks-Interactivity-Dynamic-Dimensions-and-Measures
it is using calculated field to change the data field displayed according to user selection.
Same as the example 1 you have described

In the above demo, you can click on the pencil icon to see how it works in QuickSight analysis