Forum Discussion
FILTER TABLE BASED ON SELECTED VALUE
Dear All, I have this situation. In one table i have costs and revenues for each order/job: OrderN Type Costs Date_operations Values 1 Revenue 1000 1 Cost1 01-05-2020 -300 1 ...
Greg_Deckler
Community Champion
Community ChampionYou need a complex selector like what I have attached. It is based on the concept of the Inverse Selector. Basically, you need to filter your table by date. Then you need to get a distinct list of your order id's. Your selector would check if a row's order id is IN the list.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Inverse-Selector/m-p/648290#M325
Greg_Deckler , Thank you for the solution. I am working on something similar, but I need a little more help from you. Instead of showing the last 4 weeks in the selection, can we show the current week, last week & same week last month (3 columns)?