I have a filter called Page_Type with 3 options.
I want to always have Other chosen, while giving the user to either click search or detail, but I don’t want Other being visualize for the user to see.
I am visualizing a drop down with search and detail as options while in the background other is always chosen.
Is this doable?
Hello @Phillip_Le - Thanks for posting your query. I can think of one option that may work for you.
Step 1 : Create a string based parameter and set the parameter default value as “Other”
Step 2 : Create the filter and link the parameter with that filter by selecting “custom Filter” option
Step 3 : When formatting the parameter control, you only put “Search” and “Detail” under the “Defined specific values”
This would allow you to see the dashboard at the beginning with the “Other” value being selected and data being filtered based on that. But when the use clicks the control to select other values they will not be able to find it and they will only be able to select either “Search” or “Detail”
I have tried to replicate at my end with some other dataset and sharing the snapshot for your reference. Hope this helps!
Did my suggestion help you in resolving your query? If yes, would request you to mark the post as “Solution”. This will help the community to find guidance and answers to similar question. Thank you!
Users will only be able to click “Search” or “Detail”, but is “other” chosen in the background? I would like a multi select because basically I need “Other” to always be enabled, but give the users to mix and match between search/detail (they can have both chosen at the same time).
@Phillip_Le - Thanks for your response. Based on your explanation, I believe now I have got the problem clearly. Can you please check the below step by step implementation thoughts process and let me know if this is what you are looking for.
Sample Dataset Snippet that I have used for the POC. Here I will try to have name = specific always selected in the background and when any other name(s) will be selected from the slicer, then all the records having name = slicer selection will be shown in addition to the records qualifying the criteria name = specific.
Step 1 : Create a Parameter named paramName
Step 2 : Create an “OR” Filter based on that “name” column
Step 3 : Modify the Control to configure it as List - Multiselect and in the value specification put all the values except “specific” which you don’t want to appear in the slicer selection to appear
Step 4 : Sample Run
Did my suggestion help you in resolving your query? If yes, would request you to mark the post as “Solution”. This will help the community to find guidance and answers to similar question. Thank you!
