Data labels only on last column/line point

[314mp_M0th4]

Hello, I have a time series line plot visualization in power bi. X axis are months and the y axis are some values. I want to have data labels only for the last point on the line. Is this possible?

[Anonymous · Accepted solution]

Hi @314mp_M0th4 ,

You might consider creating a measure to display the last data and then placing it on the card visual object, adjusting the card formatting background, etc. to display the card as a data label.

As @CoreyP  said, it is also possible to create dynamic format strings for measure.

Best Regards,

Neeko Tang

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

[CoreyP · Accepted solution]

I actually just did that this week. I was playing around with animating a line chart, like so:

You can accomplish this using a dynamic format string for your measure. To get the animation to work, it required a disconnected date table. Since you're not animating, it might not require the disconnected table, but I'm not sure. Here is the dynamic format string for my measure:

VAR _onmonth = MAX( CustomerRank[Date] )

VAR CustName = SELECTEDVALUE( CustomerRank[Customer] )

VAR _logic = IF( _onmonth = MAX( 'Disconnected Date'[Date] ) , CustName , " " )

RETURN

_logic

The Play Axis visual uses the disconnected date table, while the line chart uses the regular date field. I'm sure you can tweak this to suit your needs, but it's definitely possible! Hope this helped!

[Anonymous · Accepted solution]

Hi @314mp_M0th4 ,

You might consider creating a measure to display the last data and then placing it on the card visual object, adjusting the card formatting background, etc. to display the card as a data label.

As @CoreyP  said, it is also possible to create dynamic format strings for measure.

Best Regards,

Neeko Tang

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