Solved: Display text with selected values

vignesh-490 · ‎11-20-2022

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.

ryan_mayu · ‎11-20-2022

@vignesh-490

use SELECTEDVALUE to get the value in the dropdown

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

at last use "&" to connect

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

View solution in original post

v-yiruan-msft · ‎11-21-2022

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

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.