Forum Discussion
Function as visualization title depending on a slicer
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!
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])
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
2 Replies
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])
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