Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
Hello
I have a table with my equipment and oil analysis dates, and another table with oil changes.
Oil changes
Results table
In my line chart visual I see the results of all dates, but I only want results to appear from the date of change. If I implement a segmenter I would have to manually change the date depending on the change of each team, I want that to be automatic and not have to use the segmenter.
Is it possible to do that?
@Syndicate_Admin , You can filter that
example
calculate(Sum(Table1[Value]), filter(Table1, Table[Date] in values(Table2[date])))
| User | Count |
|---|---|
| 56 | |
| 39 | |
| 37 | |
| 21 | |
| 19 |
| User | Count |
|---|---|
| 140 | |
| 102 | |
| 64 | |
| 36 | |
| 35 |