Dynamic Sclier

[Amyries]

Hello,

I have a table that includes the Fiscal Year (FY) field. I want to create a slicer such that when I select FY25, the data and visuals will display both FY24 and FY25. Or select FY24, display FY24 and FY23, and similarly for other years.
Data is here: (I can't attract files or links, just can capture them)

As a newcomer to Power BI, I would greatly appreciate your assistance. Thank you!

[danextian · Accepted solution]

Hi @Amyries 

You will need a disconnected table (without relationship) as using column from a related table will show just what's been selected and then a measure referencing that table/column to be used as a visual filter

FY Filter = 
VAR SelectedFY =
    MAX ( FY[FY Number] )
VAR _FY = {
    "FY" & SelectedFY - 1,
    "FY" & SelectedFY
}
RETURN
    CALCULATE (
        COUNTROWS ( 'Date' ),
        KEEPFILTERS ( TREATAS ( _FY, 'Date'[Fiscal Year] ) )
    )

Please see the attached sample pbix.

[JennyMilf]

Thank you!

[Anonymous]

Hi @Amyries ,

If danextian's reply can help you, please remember to accept his reply as a solution to help the other members find it more quickly. Thank you!

Best Regards,
Dino Tao

[danextian]

Please accept my post as the solution.

[JennyMilf]

Thank you, but I Select FY24 as the visual just show data for FY23