Function as visualization title depending on a slicer

[mtrevisiol]

Hello everyone.

I've created a report with a slicer for the year:

and a card that shows the revenues variation of the filtered year compared to the previous one.

Is it possible to create a function that can be used as the title of the card, which shows the year selected on the slicer and the previous one? My goal would be to have "Revenues % variation from 2018 to 2019", when 2019 is selected.

Thank you so much in advance!

[amitchandak · Accepted solution]

@mtrevisiol , Yoy can create a measure and use that in the title . In title you can use a measure using fx

measure = "Revenues % variation from "  & Selectedyear(Year[Year]) -1 " to " & Selectedyear(Year[Year]) 

[Fowmy · Accepted solution]

@mtrevisiol 

Create the following measure and assign it to the Title of the visual under conditional formatting (fx):

Title Year = 
var __yr = SELECTEDVALUE(Dates[Year]) return
"Revenues % variation from " & __yr - 1 & " to " & __yr

[amitchandak · Accepted solution]

@mtrevisiol , Yoy can create a measure and use that in the title . In title you can use a measure using fx

measure = "Revenues % variation from "  & Selectedyear(Year[Year]) -1 " to " & Selectedyear(Year[Year])