Forum Discussion

MarlenePirker's avatar
MarlenePirker
Icon for Helper I rankHelper I
3 years ago

Conditional filter

Hello 🙂    I have a filter (slicer) on my report for the expected delivery date but in a table we show the desired del. date too.    Now I have the question wether it is possible to filter the e...
Need Help
vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
3 years ago

Hi marlene can you provide an example so its clearly understood what you are asking.

MarlenePirker's avatar
MarlenePirker
Icon for Helper I rankHelper I
3 years ago

I have this date filter: 

and it is used in this table: 

 

As you can see it filters planned del. Year.Week to 2022 but they also want that it automatically fitlers desired del. Year.Week to the same year als the planned del. Year. Right now you see 2024 and 2023 too, but it should only be 2022. Is it possible to do that without using another slicer? 

 

Is it clear now what I mean? 

 

Best regards, 

Marlene

  • vanessafvg's avatar
    vanessafvg
    Icon for Community Champion rankCommunity Champion
    3 years ago

    are both of these dates held in the same table?

     

    so what you are saying is, you want to filter you table by the planned year, but it should only return rows that where planned year = desired year