Show the value of a column based on a filter

[JeroDS7]

I have a simple dataset table in Quicksight with 3 columns

Sku	Category	SubCategory
1035	Food	Fruit
2565	Drink	Water
1254	Accessory	Fork

I created a parameter and linked to a filter for the Sku value and create a control to select a unique value of Sku. What I would like is a text box (or any other tool/visual) such that, when I select a specific Sku in the filter, it shows

Sku: 1035
Category: Food
SubCategory: Fruit

That is, when I select an Sku in the filter I want to print the values of the other columns for that Sku.

[ashikrahman]

Hi,

This can achieved by creating an table visual by selecting the columns and creating an filter to visual and adding that filter to an parameter.

[Xclipse]

Hi @JeroDS7

Welcome to Quick Sight community!

You can achieve this by using a combination of parameter controls and filter.

Create a Parameter for Sku:

• Navigate to the left panel, click on Parameters, then select Create a Parameter.
• Name it something like pSKU.
• Set the Data type as Integer (depending on your data type for Sku).

Create a Filter for Sku:

• Click on the Filters pane.
• Add a filter for the Sku column.
• Link this filter to the pSKU parameter by choosing “Use Parameter” and select pSKU.

[JeroDS7]

Thank you so much for your answer.
The only thing I don’t get is which type of visual are you using in your last video to display the result. If I try to do this and use a Table as a visual, it shows the selected Sku but it counts the number of the other columns

[Xclipse]

Hi @JeroDS7

I used the Table visual. Please refer the below screen shot.