Forum Discussion
Need to create Filter with Selected Column from All Column
Hi, Rakesp
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
Hello, Thanks for guidance, I did same thing, added 3 slicer, But like to make 1 slicer for all 3 slicer.
Hi, Rakesp
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