Show Relevant Values Only doesnt work as expected

[andrepgn]

Hi @rachit-ao ,
for the first part you need to create two controls (filters) one for Client and one for Category.
Then, from the Category Control, you open the Edit and go to Control Options.
Here click on “Show Relevant Values Only” and select Client as “main” control.

By doing so, when selecting a Client, only the relevant values for Category are shown.

======
You can obtain what you want in this way.
Let’s keep this as our final result:

We have three type of visuals:

• Green Title: only Client filter is applied here
• Blue Title: Client-Category filter applied
• Black Title: the row data, the ones you provided as example

The steps are:

1. Create a Parameter, e.g. SelectedClientParam, as type select String, Single Value and put a Static default value, like None
   

   

2. When you click Create, you can select if you want to add a Control. Let’s add one:

   • Give it a name, like Select Client
   • Choose Dropdown
   • Link to a dataset field
   • Select you dataset and the field which contains your Clients
   • Add
     
     

3. From the Control > Edit, select Hide Select All option…
   

   

4. Now create a new Filter

   • as type select Custom Filter
   • Filter Condition select Equals
   • The click on Use Parameters and select the one we created in the previous step

This filter must be applied only to the visuals where you want to see ONLY specific data from the selected client (e.g. in our output, the ones with Green Title)

5. We will create then another filter, this time for Category field
   • Select type as Nested Filter
   • Qualifying Condition as Include
   • As Nested Filter select Client field
   • Then once again use Equals as Filter Condition, Use Parameters and select the same parameter as before
     
     

This filter must be applied where you want to obtain the output you were describing, so where you want to compare the Categories which have at least one sale for the selected customer (e.g. in the output , the visuals with Blue Title).
As you see, these two visuals, when selecting Puma as Client, now have the values you where trying to obtain.

Let me know if this works for you!
Andrea