topic Need to create Filter with Selected Column from All Column in Report Server

Need to create Filter with Selected Column from All Column

Rakesp — Wed, 15 Dec 2021 17:26:08 GMT

Need to create Filter with Selected Column from All Column, So as to filter related table data of selected column row value

lbendlin — Mon, 20 Dec 2021 02:12:01 GMT

Your ask is not very clear. Maybe you want to teach your users how to personalize visuals? Then they can add whatever filters they want.

v-janeyg-msft — Mon, 20 Dec 2021 02:41:17 GMT

You can use slicer to filter data. In your situation, you need to use four slicers.

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards,
Community Support Team _ Janey

Rakesp — Wed, 22 Dec 2021 03:38:34 GMT

Hello, Thanks for guidance, I did same thing, added 3 slicer, But like to make 1 slicer for all 3 slicer.

v-janeyg-msft — Wed, 22 Dec 2021 06:13:23 GMT

According to your screenshot, These date columns seem to be just for marking.

You can create a column and use it in filter pane to filter data.

Like this:

Flag = IF ( table[Jan22] = 1 && table[Feb22] = 1 && table[Mar22] = 1, 1, 0 ) //According to your needs, you can use && or ||

I noticed that some columns do not seem to be numeric columns. . .You can change to number column or modify the code like table[Jan22] ="1".

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards,
Community Support Team _ Janey