Dynamic Filter Question

[sbellmore]

Hello everyone

I am looking to have a slicer or something similiar that allows the User to Choose FY23 but based on the selection of FY23, have it filter the power query or the data displayed as such. For example, User chooses FY23 in Slicer, Table displays FY23 and FY24. If they choose FY24, it would display only FY24 and FY25. I dont know why im blanking on the best way to approach this but would appreciate anyones help. 

Thanks

[sbellmore · Accepted solution]

In Order to get this done.  I made this table Below. I used The Fiscal Year column in the slicer and Used the FY column to filter the master table FY column in a one to many relationship. This lookup table filtering the master table in one direction. By Selecting FY 23 on slicer it now filters the table for bother FY23 and FY24

Fiscal Year         FY

FY 21	FY 21
FY 21	FY 22
FY 22	FY 22
FY 22	FY 23
FY 23	FY 23
FY 23	FY 24
FY 24	FY 24
FY 24	FY 25
FY 25	FY 25
FY 25	FY 26
FY 26	FY 26
FY 26	FY 27