Forum Discussion
Dynamic title to display multiple selected
- 5 years ago
Hi, Anonymous
Could you tell me whether your problem have been solved?
You can also try measure as below to create dynamic title:
Selected Month = VAR selectedmonth = VALUES ( 'financials'[Date].[Month] ) RETURN "Sales by Month: " & IF ( COUNTROWS ( selectedmonth ) = COUNTROWS ( ALL ( 'financials'[Date].[Month] ) ), "All", CONCATENATEX ( VALUES ( 'financials'[Date].[Month] ), 'financials'[Date].[Month], "," ) )Please check my sample pbix file for more details.
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hey Anonymous ,
can you post your measure?
This makes it easier to help you.
Did you put multiple values together with CONCATENATEX?
Hey Anonymous ,
I've seen you deleted the reply.
The reason there was that you used the FORMAT function on the already concatenated string.
So if the string looks like "01 20201, 02 2021, 03 2021" and you use the FORMAT function on it, it would not work because the format doesn't fit.
Does this solve your issue?