Forum Discussion

Hugo999's avatar
Hugo999
Frequent Visitor
1 year ago
Solved

Show only last value in line chart?

Dears I've created a line chart in Power BI. How can I display the value of the last data point? I only want to see the value of the last data point, all other data point labels should not be shown....
Need Help
  • TomasAndersson's avatar
    TomasAndersson
    1 year ago

    Hi!

    I don't know how your data is structured so you have to adjust accordingly, but basically you want to figure out the max date where there is a value and then return blank() for all values that aren't the last point.

     

    LastValueLabel = 
VAR __LastDate = 
CALCULATE(MAX('Dates'[Date]), ALL('Dates'))
RETURN
IF(
    SELECTEDVALUE('Dates'[Date]) = __LastDate,
    [YourMainMeasure],
    BLANK()
)

     

    And then add that measure as the Value on the Data Label for your series.

     

    Good luck!

SamWiseOwl's avatar
SamWiseOwl
Icon for Super User rankSuper User
1 year ago

Hi Hugo999 

There are two ways you could try a measure or a Top Filter.

Create a measure that tests if the current data point is equal to the highest in that column.

Right click on your table and choose create new measure

Last point =
If(

SelectedValue(table[YY-MM column]) = Calculate(Max(table[YY-MM]), AllSelected(table[YY-MM]))
, [Your calculation]

,Blank()
)


To apply a filter go the Filter pane and under Filters on this visual, go to your [yy_mm] column.

Change it from basic filters to Top N.

Choose 1 and then use the [yy-mm] field in the calculation part of the filter.

Change this to MAX.

This method might remove more than your want!