Assume that there are 5 Filters F0, F1, F2, F3, F4 and F5 Among which following are the cascading Filters F0 -> F2 F3 -> F4 -> F5 When i render the report for the first time -> The functionality should be F0(Multi Select) Has the default value selected F1(Multi Select) Has the default value selected F2(Multi Select) It has values but nothing is selected by default, data loaded is based on F0 selection F3(Single Select) Has the value and the Default Value is selected as N/A F4(Multi Select) Should select the default value N/A when the F3 is selected to N/A else it should select values based on the F3 selection F5(Multi Select) Should select the default value N/A When the F4 is selected to N/A else it shoult select values based on the F4 selection Following is the Issue that we are facing now When we render the report for the first time all the filter are behaving normally except the filter F5 which is disabled but when we select the value for filter F2 (which was empty when it was loaded for the first time)then it is getting displayed When we were trying to resolve the issue we identified that the filter F4 being a multiselect filter we use this expression =REPLACE(JOIN(Parameters!F4.Value, ","), "'", "") in the filter value that is passed to the dataset of filter F5. we doubt that this might be causing the issue. Is there anyone faced similar kind of an issue or is there any solution?

yogesh, Well, first of all I think you had the issue of F5 getting disabled on first run. And, you resolved it by selecting F2. So, here is the thing that all parameters must contain a value for dependent parameters getting enabled. Second, you think that =REPLACE(JOIN(Parameters!F4.Value, ","), "'", "") for F4 is giving you the problem for F5. Can you share details as to whether you are using Sql server or cube or any other database? Why are you removing ' . Are you expecting it to be in the data. Regards, Manoj *Happy to help http://experiencingmsbi.blogspot.com/

Manoj, I am using SQL Server We are joining the filter values using =REPLACE(JOIN(Parameters!F4.Value, ","), "'", "") and then we have a table valued funtion in Sql Server which will convert the joined string into individual values. Then we will perform filtering based on the values. I am aware that there should be value in all parameters. The filter F2 contains values and only thing is that nothing is selected when we run it for the first time and more over F2 is dependent only on F0. F5 is dependent on F4 and F3 and both F4 and F3 has default values selected. If you see the dependent filter F3 -> F4 -> F5 The default value in F3 is 'N/A' and the values in F4 is getting loaded The default value in F4 is 'N/A' and ideally F5 should be loaded and selected with 'N/A' but why is it getting disabled?

Hi yogeshkumar.ramachandran, Based on my test, I add three parameters f3,f4,f5: f3,single-value parameter, default value “N/A” f4,multi-value parameter, default value “N/A”, and the dataset f4 used to retrieve Available Values is filtered in the query “ where <columnName> = @f3” f5,multi-value parameter, no default value, and the dataset f5 used to retrieve Available Values is filtered in the query “where <columnName> In (@f4)” All parameters show right. So I suggest you to filter the value based on dataset query level to have a test. Or replace your filter expression =REPLACE(JOIN(Parameters!F4.Value, ","), "'", "") with In [@F4 ] as If the issue still exists, could you please provide me more information about all datasets structure for those parameters and the steps to add the filters and create parameter? Thanks, Lola Please remember to mark the replies as answers if they help.