Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi, can anyone please help me with this?
I started working on a year to date line chart for 5 years. Each line would be 1 year. I managed to do that following this video on youtube.
Then I wanted to turn on the labels but only for the last year. When I turned on the labels, they were for each year. I searched how to turn on only the last label and found the following video.
However I cannot figure out how to combine these 2 processes in order to get the final result. Can anyone please help? Thank you
@nikcus One way you can do this is to incorporate a contant Y-axis line and set it to your Lastest Population measure:
You can make the line transparent so only the label shows.
I've attached the PBIX so you can see what I did too.
Respectfully,
Zoe Douglas (DataZoe)
Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/
Hi Zoe, thank you so much for suggested solution! But does it mean that I need to create a separate measure to get a value for each year and then add it to the Y-axis constant line? I created a measure that shows the cumsum at the end of the year, for the rest of the year it is blank values. When I throw that measure into the Values in Y-axis Constant Line, it gives me a 0, instead of the values in the column "test" as you can see attached in the screenshot. I hope I described it in an understandable way...
@nikcus are you able to share your test measure?
Respectfully,
Zoe Douglas (DataZoe)
Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/
Yes, here it is:
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 41 | |
| 38 | |
| 36 | |
| 30 | |
| 28 |
| User | Count |
|---|---|
| 128 | |
| 88 | |
| 79 | |
| 67 | |
| 62 |