Conditionally display message and populate table based on parameter selection

Q&A
, ,
1

Hi all,

I’m building a Quick Sight report where I have:

  • Two multi-select parameters:
    1. One for dimensions (Mix of different data types)
    2. One for measures (Output will be Sum for each)

Requirements:

  1. When no selection is made in either parameter:
  • A table visual should display the message:
    "Please select either Dimension/Measure to build the report"
  • The message should appear in the same table visual.
  1. When the user selects any dimension or measure:
  • The message disappears.
  • The table visual should populate the corresponding data.

Additional details:

  • The table should ideally show only the selected columns, with dimensions appearing first, then measures.
  • I want to know the best way to:
    1. Show/hide the message dynamically in the same table.
    2. Populate the table with the selected dimensions and measures dynamically.

Has anyone implemented a similar setup? Any guidance or workaround for this in Quick Sight would be appreciated.

2

Hello @QS_User

Greetings of the day!

For your use-case, the 2nd part: Populate the table with the selected dimensions and measures dynamically. can be achievable. You can refer to the below demo which depicts a similar use-case:
[+] https://democentral.learnquicksight.online/#Dashboard-TipsAndTricks-Interactivity-Dynamic-Dimensions-and-Measures

You can also click on the format pencil sign, which will load the analysis for you to refer

For: 1. Show/hide the message dynamically in the same table. - We may not have any option to display this. On first load, it will show you the static default values set up for the parameters.

Hope this helps.

Have a nice day!

3

Hi @QS_User,

Hope this message finds you well! Were you able to see msnehali’s message and/or were you able to find a workaround yourself in the meantime? If we do not hear back within the next 3 business days, I’ll go ahead and close/archive this topic.

Thank you!

4

Hi @QS_User,

Since we have not heard back, I’ll go ahead and close this topic. However, if you have any additional questions, please feel free to post again in the Quick Suite Community and link this thread for any relevant info!

Thanks!