How to show multiple year in a single card

[0Experience]

Hello Everyone,

I've got a chart showing data for three years and their values. Also, there are two cards showing the year and its count/value. For example, for 2022.

When I select all three years, the "sum of count" card shows the total count right, but the year card only shows one year. I know I can set it to show the first or last year.

But, can it show "2021, 2022, 2023" when I select all three years? And when I pick just one year, it shows that year and its value. If I choose multiple years, it shows all those years and the total count?

Power bi file (Google Drive)

Thank you 

[Alex87 · Accepted solution]

Hello,

This DAX measure should do the trick.

Selected Years = 
CONCATENATEX(VALUES('MyData'[Year]), 'MyData'[Year], ", ", 'MyData'[Year], ASC)

If it answers your need, please mark my reply as the solution. Thanks!

[0Experience]

Thanks @Alex87 

It works