Forum Discussion

mtrevisiol's avatar
mtrevisiol
Icon for Helper V rankHelper V
5 years ago
Solved

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 crea...
Need Help
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    5 years ago

    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's avatar
    Fowmy
    5 years ago

    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's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

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])