Skip to main content

    Power BI

    Needs Votes

    Auto Select filter values upon user entry with wildcard

    Vote (16) Share
    Bert's profile image

    Bert on 08 Nov 2019 19:12:51

    In the existing Filter visual, add the functionality to type in values with a wildcard, and automatically select ALL values from that result set in the filter object.

    Comments (1)
    Bert's profile image Profile Picture

    Arie Saraf on 15 Aug 2020 08:45:20

    RE: Auto Select filter values upon user entry with wildcard

    I propose those wildcards:
    Sale !Sales for Sale but not Sales (! instead -)
    "Sale" for exact whole word Sale
    xxx* for starting with xxx
    *xxx for ending with xxx
    *xxx*yyy* for containing xxx and yyy (no matter in what order)
    x?y for xay, xby, x1y, x2y, .... but not xaby
    x#y for x1y, x2y, ....
    x&y for xay, xby, ....