Get distinct years in title of a chart

[Anonymous]

Hi all,

New to the forum! so pardon me if my questions are not clear.

I have a year column which has 2020, 2019, 2018 and so on. I have a matrix chart whcih shows some detailed view of information.

My question is, How do i get the above years in the title of matrix chart so that users are informed that they are seeing infomation for these years?

Please help me.

[amitchandak]

@Anonymous , Not very clear. You can give year in the Column of matrix

https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/

Can you share sample data and sample output in table format?

[Anonymous]

Please see the below image. in the line chart i have years showing based on a filter applied with measure "check measure"

CheckMeasure = IF(MAX(table[Year])>(MAX(dimdate[YearL])-3) && MAX(table[Year])<=MAX(dimdate[YearL]),1,0)

This measure takes the year from the "table[Year]" and find last 2 years and plot thier monthly values in the line chart.

in the title highlighted below "Bill Rate by Specialities :- All Years" instead of "All Years" i want to show the years which are in the line chart.

[FarhanAhmed]

Create a measure to get all concatenated year values 

Title = "Data of " & CONCATENATEX(DISTINCT(Date[Year]), Date[Year], ",") 

Then right click on title and click "Conditional Formatting"

Then Select "Title" in Based on Field

 

[Anonymous]

@FarhanAhmed Thanks. I did the same. But this measure gives all the years like 2020,2019,2018,2017,2016 when there is no selection made. I would like to show only the years showing in the line chart that is 2020,2019, 2018 only. 

[v-deddai1-msft]

Hi @Anonymous ,

Would you please try to use:

Title = "Data of " & CONCATENATEX(DISTINCT(Table[Year]), Table[Year], ",") 

Best Regards,

Dedmon Dai

[FarhanAhmed]

Try this, including Crossfiltering to get only years from Fact Table.

Title = "Data of " & CALCULATE(CONCATENATEX(DISTINCT(Date[Year]), Date[Year], ",") ,CROSSFILTER('Date'[Date],table[Date],Both))