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.
Go to Solution.
use SELECTEDVALUE to get the value in the dropdown
format(today(),"mmmm") to get month name
at last use "&" to connect
Proud to be a Super User!
View solution in original post
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")
Find out who won the T-Shirt Design Challenge and the top 3 finalists.
Find out more about the March 2023 update.
In this session, we'll examine important design issues and decisions that arise when developing with Power BI embedding.