Last date in table should be displayed in different colour line chart power bi

[Anonymous]

Hi Team,

Wanted to showcase last date value in different color like as attached snapshot.

(for ex: as per the below data 29-sep-2020 is the lastdate , lastdate value should shoecase in different color)

I am having the below data:

Date                 Value

22-Sep-20          20
23-Sep-20          40
24-Sep-20          80
25-Sep-20          60
26-Sep-20          20
27-Sep-20          30
28-Sep-20          60
29-Sep-20          90

Expected Output:

Thanks In Advance

[amitchandak]

@Anonymous , if color the line you have to create a measure that gives data of last two days

Measure =
var _max = maxx(allselcted(date), date[date])
var _min = maxx(allselcted(date), date[date]) -1
return
calculate([measure], filter(Table[date], date[date] <=_max && date[date]))

Or create a color measure. First, create a bar and use it in conditional formatting. Use the field value options. Once done convert Bar to line visual

Measure =
var _max = maxx(allselcted(date), date[date])
return
if(Max(Date[date]) =_max, "green", "Blue")

refer my blog

https://community.powerbi.com/t5/Community-Blog/Display-Label-Only-on-the-Last-Data-Point-of-the-Line-Visual-for/ba-p/1253464

or

refer:https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values

[Anonymous]

Hi Amit,

I need toshow case last non blank value in different colour. For Ex: 23-sep value should show in different colour.

Date                     Value

22-Sep-2020   30

23-Sep-2020  40

24-Sep-2020 Null

Thanks In Advance