I want to select a filter based on selecting a filter other filet show other wise it should hide

Hello Team,

I have few filters,

Filter A
Filter B
Filter C
Filter B

Filter A will be visible and other filter should be hided but if i select some value from the Filter A then other filter should be visible until then it should hide.

How to do this, please help me with this thank you.

Thanks & Regards,
Deepak Kumar Pradhan

Hi @Deepak1
you need to use parameter (A, B, C).

  • create the parameter
  • add parameter control to sheet
  • assign the parameter to the filter.
  • set a rule to each filter control

Then you can hide/show the controls via parameter value.

BR

Hello ErikG,

Hope you are doing well,
Thank you for the response,

but what value i will pass when hide the other filter i can not give any specific value because there so many values in the filter when i select any value in the filter A then other filter should be visible.

image

maybe something like a simple “.” i guess that will not be a valid selection.
grafik

Thank you @ErikG, it worked thank you so much.

Have a great day !!

Can I know how you achieved this?

@Deepak1 , I guess my scenario and yours is same. In the below image I have segment and customer name. once I select the value from segment then only the customer’s name needs to be shown until then it should be hidden. I tired the above rules, but it is not working.

Dynamic visibility of filters based on selection - Question & Answer - Amazon QuickSight Community - From my post I came to know the dynamic visibility is not possible.

Hi Vidya,

First you have to create a parameter called segment.

Then in customer name filter first you have to hide it by default then Add rule choose that parametere that you have created for segment then chose does not equal ‘,’ then show this visual.

Then it should work in segment whenever you choose a value then only it will show otherwise it will not show.

Thank you let me know if thia work.

Thanks & Regards,
Deepak Kumar Pradhan

Hi,
Thanks for the reply. It worked but if I click on the select all from parameter control(Segment) the Filter control(Customer name) is getting hidden.

My final doubt - suppose if I have three filters Country, State and City. The state filter should display value related to India when “India” is selected from the country filter. Likewise, the city filter should be visible when a specific state, such as “Kerala,” is chosen from the state filter. Otherwise, need the city filter to be hidden.

how to achieve this?

Hi Vidya,

yes in segment if you select “Select All” the customer name filter will be hidden right because no value is selected from the segment filter.

your use case also same right that if any value is selected from segment then only customer name filter will be visible otherwise it should hidden and exactly thats how it is working.

and regarding the question(Country, State and City) it will work the same way.

Thanks & Regards,
Deepak Kumar Pradhan

Thanks for the reply @Deepak1.

No Problem, is your issue resolved ?

yeah it is working but if i select all country again I want city need to be hidden.But it is showing up.