Display Data Label on the last date for multiple lines chart in power BI

[insp77]

Hi,

I have a data set where 3 or the 4 column varaibles are filtered  and plotted.  Current my chart shors Growth Since Feb-2020 for 3 selected categories and selected geography.  I generated a BI line charts, but I now want to display only the last data point for these 3 lines.  Is there an efficient way of doing so?  Please see my attached data set

DATE	GEO	Class Of Workers	Current Month	Growth From Feb-2020
11/01/2021	Canada	Total employed, all classes of workers	19297.6	0.008
11/01/2021	Canada	Employees	16659.9	0.024
11/01/2021	Canada	Public sector employees	4171.4	0.071
11/01/2021	Canada	Private sector employees	12488.5	0.01
11/01/2021	Canada	Self-employed	2637.7	-0.084
11/01/2021	Ontario	Total employed, all classes of workers	7586.7	0.012
11/01/2021	Ontario	Employees	6507.7	0.032
11/01/2021	Ontario	Public sector employees	1510.4	0.063
11/01/2021	Ontario	Private sector employees	4997.4	0.023
11/01/2021	Ontario	Self-employed	1079	-0.093
12/01/2021	Canada	Total employed, all classes of workers	19376.2	0.012
12/01/2021	Canada	Employees	16737.4	0.029
12/01/2021	Canada	Public sector employees	4207.7	0.08
12/01/2021	Canada	Private sector employees	12529.7	0.013
12/01/2021	Canada	Self-employed	2638.8	-0.083
12/01/2021	Ontario	Total employed, all classes of workers	7639.2	0.019
12/01/2021	Ontario	Employees	6525	0.035
12/01/2021	Ontario	Public sector employees	1522.6	0.072
12/01/2021	Ontario	Private sector employees	5002.5	0.024
12/01/2021	Ontario	Self-employed	1114.2	-0.063
01/01/2022	Canada	Total employed, all classes of workers	19176.1	0.002
01/01/2022	Canada	Employees	16524	0.016
01/01/2022	Canada	Public sector employees	4200.2	0.078
01/01/2022	Canada	Private sector employees	12323.8	-0.004
01/01/2022	Canada	Self-employed	2652	-0.079
01/01/2022	Ontario	Total employed, all classes of workers	7493.5	0
01/01/2022	Ontario	Employees	6378.7	0.012
01/01/2022	Ontario	Public sector employees	1509.8	0.063
01/01/2022	Ontario	Private sector employees	4868.9	-0.003
01/01/2022	Ontario	Self-employed	1114.7	-0.063
02/01/2022	Canada	Total employed, all classes of workers	19512.7	0.019
02/01/2022	Canada	Employees	16879.2	0.038
02/01/2022	Canada	Public sector employees	4208.1	0.08
02/01/2022	Canada	Private sector employees	12671.2	0.024
02/01/2022	Canada	Self-employed	2633.4	-0.085
02/01/2022	Ontario	Total employed, all classes of workers	7687.8	0.026
02/01/2022	Ontario	Employees	6607.5	0.048
02/01/2022	Ontario	Public sector employees	1513.9	0.066
02/01/2022	Ontario	Private sector employees	5093.6	0.043
02/01/2022	Ontario	Self-employed	1080.3	-0.092

[Anonymous · Accepted solution]

Hi  @insp77 ,

Here are the steps you can follow：

1. Create table with Enter data.

2. Create measure.

Measure_Growth From Feb-2020 =
CALCULATE(SUM('Table'[Growth From Feb-2020]),FILTER(ALL('Table'),'Table'[DATE]=MAX('Table'[DATE])&&'Table'[Class Of Workers]=MAX('Table2'[Table2Class Of Workers])))

3. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[amitchandak]

@insp77 , Based on what I got, check if this blog can help

https://community.powerbi.com/t5/Community-Blog/Display-Label-Only-on-the-Last-Data-Point-of-the-Lin...