Forum Discussion
Display Data Label on the last date for multiple lines chart in power BI
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 |
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
2 Replies
- amitchandak
Super User
insp77 , Based on what I got, check if this blog can help
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
