Forum Discussion

udian's avatar
udian
Helper III
8 years ago
Solved

Or Condition Between Report Level Filters

Hi,

 

I have a Power BI Report with 2 report level filters. I am looking for a way to put an OR condition between the 2 filters.

 

Is there a way to achive this without creating a special measure the imlement the or condition (the report have many measures).

 

Thanks!

  • Ah ok, understood.

     

    I dont think you can do this then, you probably need to implement the filter as part of your measures or create a custom column and use that to filter with.

4 Replies

  • alexei7's avatar
    alexei7
    Continued Contributor

    Hi udian,

     

    If you select "Advanced filtering" from the filter menu, you will see that you can add two conditions and there's a radio box to select either "And" or "Or" for the conditions.

    • udian's avatar
      udian
      Helper III

      Hi alexei7,

       

      The OR option in advanced filtering is for a specific filter and not between two different filters so this solution is not what i am looking for.

      • alexei7's avatar
        alexei7
        Continued Contributor

        Ah ok, understood.

         

        I dont think you can do this then, you probably need to implement the filter as part of your measures or create a custom column and use that to filter with.

  • Anonymous's avatar
    Anonymous
    Not applicable

    udian were you able to resolve this issue. I have a situation where i have to use OR Condition between two date fiters.