How to write the expression to work according when selected in filter ?

[suvechha_b]

Hi All ,

The report is not working according to the filter selection. Sample model attached. there are two reports present in two tab.Screenshot attached.

Sample model attached.

Thanks,

[tresesco]

The Status columns in the charts are not coming directly from Status field, rather they are calculated values (check expression tab). If you want them as in selection, replace the expression for Status column with simple expression =Status

[suvechha_b]

Hi Tresesco ,

How to handle when Status not selected.

[tresesco]

When there are multiple possible values, you can choose to see it as null (as you see now) or choose to see all of them separated by delimiter. For multiple values, you can try expression like: = Concat( Distinct Status, ',' )