Accentuating a period that is longer than 10 days and higher than 15 degrees

[Stefanve]

Hi,

In the scenario below i have a date and temperature column.

What we are trying to visualize is accentuating a period that is longer than 10 days and higher than 15 degrees. Like the Excel example below.

Who can help me visualise this?

Thanks,

Stefan

[ikor42 · Accepted solution]

Hi,
try this measure:

Temperature_15_and_higher =

VAR _cur_date = SELECTEDVALUE ( Temp[Date] )

VAR _first_date_before_below_15 =

MAXX (

FILTER (

ALL ( Temp ),

Temp[Date] <= _cur_date &&

Temp[Date] >= _cur_date - 9 &&

Temp[Temprature] < 15

),

Temp[Date]

)

VAR _first_date_after_below_15 =

MINX (

FILTER (

ALL ( Temp ),

Temp[Date] >= _cur_date &&

Temp[Date] <= _cur_date + 9 &&

Temp[Temprature] < 15

),

Temp[Date]

)

VAR _number_of_days =

IF ( ISBLANK ( _first_date_before_below_15 ), 10, INT(_cur_date - _first_date_before_below_15) ) +

IF ( ISBLANK ( _first_date_after_below_15 ), 10, INT(_first_date_after_below_15 - _cur_date) ) -

1

RETURN

IF ( _number_of_days >= 10, SELECTEDVALUE(Temp[Temprature]), BLANK() )

We can put this measure along with Temprature field on the visual. The result is next: