Forum Discussion

mike_viz_lord's avatar
mike_viz_lord
Frequent Visitor
5 years ago
Solved

Filter table if field contains value selected from another table

TableA Submission ID Submission State 1 IL 2 IL;NC 3 NC 4 ND;NC;IL   TableB Policy ID Policy State 1 IL 2 NC 3 ND 4 IL 5 IL 6 IL 7 IL 8 ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi mike_viz_lord,

    AFAIK, the slicer does not support advanced filter effects.

    I think you can create a new table(not existed relationship to the raw table) as the source of the slicer, then you can write a measure formula with search/find function to apply filter effects and use it on your visual level filter.

    Applying a measure filter in Power BI - SQLBI

    If the above not help, you can share a sample pbix file to test.

    Regards,
    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi mike_viz_lord,

AFAIK, the slicer does not support advanced filter effects.

I think you can create a new table(not existed relationship to the raw table) as the source of the slicer, then you can write a measure formula with search/find function to apply filter effects and use it on your visual level filter.

Applying a measure filter in Power BI - SQLBI

If the above not help, you can share a sample pbix file to test.

Regards,
Xiaoxin Sheng