cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

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

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

1 ACCEPTED SOLUTION
Regular Visitor

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:

Regular Visitor

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:

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors