Need some idea to add a message when a value is selected from a filter

[Tarunika]

Hi all,

This is the report which iam working on so here now i need a help 

To calculate the standard deviation and mean we are using different algos so when we select a value from a week end date filter i want a message to be displayed as for this week i.e 14th feb Algorithm LODA is used so how can i add that text please help me

[Anonymous]

Hi @Tarunika ,

Assum "Algorithm LODA" comes from a column called [algos] and is related to [week end date].

Then you could create a measure like below add it to card visual.

measure = 
var _week end date = selectedvalue('table'[week end date])
var _algos = calculate(max('table'[algos]),filter(allselected('table'),'table'[week end date] = _week end date))
return
_week end date&" "&_algos

If I misunderstood your meaning please show some sample data and expected result to us.

Best Regards,

Jay

[philouduv]

Hello @Tarunika , 

I would advice you to create a textbox with a dynamic value base on your filter:

To do so insert textbox then click on + value and select the field thie value should be based on.

Best regards,

[Tarunika]

The Requirement is when i selected the value 14-02-2022 from the week start date i want the messase  From 14-20-2022 Algorithm  LODA is used for the events" to be displayed in the chart or anywhere else in the report how can i achieve this please help me i dont have any seperate colums for algos in my data 👉"Sample Report" 

Thanks