Forum Discussion

Torty's avatar
Torty
New Member
4 years ago

Settings Filter PowerBi Desktop

Dear Community, I am currently working my way into PowerBi. Unfortunately, I can't find a way to create a filter with more than 2 fields in PowerBi Desktop. Is there a way to enter multiple options in one field?
In my case, for example, for postcodes 66* and 56* and 57*. If I separate them with semicolons or commas, the filter no longer works and I get no results.
This would work via the multiple selection, but postcodes are added here and I always have to add them manually.
I could also go via postcode ranges, for example 56* to 66*, but I can't find any corresponding characters there either.

Thank you and have a good week!

Regards
Torty

 

Need Help

2 Replies

  • Arul's avatar
    Arul
    Super User
    4 years ago

    Torty ,

    Select basic filtering and choose the filters you want to apply,

    Thanks,

    Arul

  • Torty's avatar
    Torty
    New Member
    4 years ago

    Hello Arul,
    thanks for your advice.
    I can select the postcodes via the basic filter, absolutely correct.
    However, new postcodes are added here every day and I then have to select them manually again and again.
    Unfortunately, this is not a solution in the long run. Therefore, I would like to set the filter to postcode areas.