Display text with selected values

[vignesh-490]

Hi ,

1. Steel is one dropdown

2.April is a date field

I wanted to display the page with the dropdown selected (ie Steel selected for example) and the date should display till current date (ie November for example)

How can i achieve this in Desktop.

[yingyinr]

Hi @vignesh-490 ,

You can create a measure as below and put this new measure onto a card visual just as below screenshot...Please find all the details in the attachment.

Measure = SELECTEDVALUE('Table'[Column1])&" Till "&FORMAT(TODAY(),"MMMM")

Best Regards

[ryan_mayu · Accepted solution]

@vignesh-490 

use SELECTEDVALUE to get the value in the dropdown

format(today(),"mmmm") to get month name

at last use "&" to connect