Forum Discussion

vignesh-490's avatar
vignesh-490
Frequent Visitor
3 years ago
Solved

Display text with selected values

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.

 

 

 

  • vignesh-490 

    use SELECTEDVALUE to get the value in the dropdown

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

    at last use "&" to connect

2 Replies

  • vignesh-490 

    use SELECTEDVALUE to get the value in the dropdown

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

    at last use "&" to connect

  • Anonymous's avatar
    Anonymous
    Not applicable

    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