Today value on line graph

[Anonymous]

I'm trying to get today's value (a point or vertical line) to appear on a line graph if that's possble?

I have a simple table of values

 and want to get the value that today is closest to e.g. TODAY = 10/12/2021 therefore 10/10/2021 value 24

PBIX attached

https://www.dropbox.com/s/utwcn6vwl8xedfp/Set%20Limit%20of%20Future%20Appointment%20within%201%20Mon...

[v-janeyg-msft]

Hi, @Anonymous 

According to your description, I think you can create a measure to display your desired result.

Like this:

Measure5 =
VAR a =
    MAXX ( FILTER ( ALL ( 'Table 3' ), [Column1] <= TODAY () ), [Column1] )
VAR b =
    MINX ( FILTER ( ALL ( 'Table 3' ), [Column1] >= TODAY () ), [Column1] )
VAR c =
    IF ( TODAY () - a >= b - TODAY (), b, a )
RETURN
    IF (
        SELECTEDVALUE ( 'Table 3'[Column1] ) = c,
        MAX ( 'Table 3'[Column2] ),
        BLANK ()
    )

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards,

Community Support Team _ Janey

[Anonymous]

Hi,

Thanks for this.

I've used the following formula to attempt your solution:

Measure5 = 

VAR a =
 MAXX ( FILTER ( ALL ( 'Table' ), [Value] <= TODAY () ), [Value] )
 VAR b =
 MINX ( FILTER ( ALL ( 'Table' ), [Value] >= TODAY () ), [Value] )
VAR c =
 IF ( TODAY () - a >= b - TODAY (), b, a )
RETURN
 IF (
 SELECTEDVALUE ( 'Table'[Value] ) = c,
 MAX ( 'Table'[Value] ),
 BLANK ()
 )

but still blank values. Any advice on this would be greatly appreciated.

[v-janeyg-msft · Accepted solution]

Hi, @Anonymous 

I am back. The code in my sample is no problem. But you modified it wrong when you used it.

I used your sample, and modify it.

Try this:

Measure5 =
VAR a =
    MAXX ( FILTER ( ALL ( 'Table' ), [Date] <= TODAY () ), [Date] )
VAR b =
    MINX ( FILTER ( ALL ( 'Table' ), [Date] >= TODAY () ), [Date] )
VAR c =
    IF ( TODAY () - a >= b - TODAY (), b, a )
RETURN
    IF (
        SELECTEDVALUE ( 'Table'[Date] ) = c,
        SELECTEDVALUE ( ( 'Table'[Value] ), BLANK () )
    )

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.

Best Regards,

Community Support Team _ Janey

[amitchandak]

@Anonymous , Create a second measure and plot that

measure 2= calculate(sum(Table[Value]), filter(Table, Table[Date]=Today())

or create bar and do condition formatting using this measure

if(max(Table[date]= Today(), "Red","blue")

or

if(max(Table[date]= Today(), "Red", blank() )

use that in conditional formatting using field value option and then convert bar to line

How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4