Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Dynamic Test based on slicer selection -Selected value

Hi Experts   Based on the Month slicer Selection is would like my text to change accordingly. So if ythe user select from the month slicer Feb   AF / Apples Journey Time: Reported Feb 2019 - Jan ...
Need Help
  • ibarrau's avatar
    ibarrau
    5 years ago

    Hi, you can create a measure that will return text. Let's see how can we build the following. Assuming you have a Calendar Table for that date filter:

     

    Text Measure =
VAR __date = MIN(CalendarTable[Date])
VAR __first_date = EDATE(__date, -1)
VAR __second_date = EDATE(__date, -12)
RETURN
CONCATENATE(
    "AF/Apples Journey Time: Reported ", 
    FORMAT(__first_date, "MMM YYYY") 
    & " - "
    & FORMAT(__second_date, "MMM YYYY")
)

     

    Hope that helps,

ibarrau's avatar
ibarrau
Super User
5 years ago

Hi, you can create a measure that will return text. Let's see how can we build the following. Assuming you have a Calendar Table for that date filter:

 

Text Measure =
VAR __date = MIN(CalendarTable[Date])
VAR __first_date = EDATE(__date, -1)
VAR __second_date = EDATE(__date, -12)
RETURN
CONCATENATE(
    "AF/Apples Journey Time: Reported ", 
    FORMAT(__first_date, "MMM YYYY") 
    & " - "
    & FORMAT(__second_date, "MMM YYYY")
)

 

Hope that helps,