Forum Discussion
Dynamic title with multiple years selected
Hi everyone.
I'm trying to create a dynamic title that shows the quantity bought from a certain selected supplier in one ore more years, i.e.:
The problem is that it doesn't show me any selected year, even in the case I select only one single year.
This is the measure I wrote:
Can you help me? Thanks!
You could check the below pbix file:
5 Replies
- amitchandak
Super User
mtrevisiol , change concatenateX like
concatenateX(values(Calendar[Date].[Anno]), calculate(max(Calendar[Date].[Anno])))
My advice would be to create a year column and use that in place of [Date].year
- V-lianl-msft
Community Support
Hi mtrevisiol ,
Based on your description, I created a test file, which runs well with the same measure.
Please check the relationship between the date table and other tables.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.- mtrevisiol
Helper V
Hi V-lianl-msft, thank you for the answer. Where can I find the file?
- V-lianl-msft
Community Support