If Slicer Selected

[SLima]

If Slicer Selected year, show selected year, if not show last year.

how to do this?

[VahidDM · Accepted solution]

Hi @SLima 

You need to use SELECTEDVALUE to find that.

SELECTEDVALUE([Column you added to Slicer], Year(Today())-1)

Or use the PREVIOUSYEAR rather than Year(Today())-1.

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!