cancel
Showing results for
Did you mean:
Highlighted
Member

11 REPLIES 11
New Contributor

## Re: Display values in 10 mins interval

@Samrawit21

Community Support Team

## Re: Display values in 10 mins interval

Hi @Samrawit21,

I'd like to suggest you add a calculate column to convert time value as specific range. Then you can create a time interval table and build relationship between above column and time interval table column.

Table sample:

```Time interval =
SELECTCOLUMNS (
GENERATESERIES ( TIME ( 0, 0, 0 ), TIME ( 23, 59, 59 ), TIME ( 0, 15, 0 ) ),
"Start", [Value],
"End", [Value] + TIME ( 0, 14, 59 ),
"Index", (
HOUR ( [Value] ) * 60
+ MINUTE ( [Value] )
)
/ 15,
"Rolling interval", [Value]
)
```

After these steps, you can use time interval column(rolling interval) and original table amount to create visual graph.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

For learning resources/Release notes, please visit: | |
Member

## Re: Display values in 10 mins interval

Hello @v-shex-msft  Sorry for replying late it was a Christmas break
I didn't understand your solution and it is not me who accepted it as a solution 🙂
How can I create a calculated column to convert time value as a specific range? I have created a calculated column, time interval(time2) and made a relationship between rolling interval and time2 column, but it didn't solve my problem(it still shows me 6 body values in 10 mins) and when I try to use rolling interval on a shared axis the other columns from the original table doesn't display value on the visualization(For example, Airflow and body value)
Below is the time interval column I created

time2 = DATE(YEAR(CombinedTable[Date]),MONTH(CombinedTable[Date]),DAY(CombinedTable[Date]))+TIME(HOUR(CombinedTable[Date]),FLOOR(MINUTE(CombinedTable[Date]),10),0)

Community Support Team

## Re: Display values in 10 mins interval

HI @Samrawit21,

Can you please share a sample pbix file with some sample data for test?

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

For learning resources/Release notes, please visit: | |
Member

## Re: Display values in 10 mins interval

Hi @v-shex-msftdon't have the permission to upload .pbix files

Community Support Team

## Re: Display values in 10 mins interval

HI @Samrawit21,

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

For learning resources/Release notes, please visit: | |
Member

## Re: Display values in 10 mins interval

To revise my question
On the visualization, The body column shouldn't show values more than 3, because we only have 3 body sensors in the room. Whenever there is someone in the room(near to the sensor) the body sensor can send values more than once in 10 mins interval , So whenever the body sensor sends a value(1) more than once in 10 mins interval I want to take only 1 value for each body sensor ABC, DEF, GHI, So I can see how many people were in the room in 10 mins interval.

I hope it's clear.

Member

## Re: Display values in 10 mins interval

@v-shex-msftdoes the file open for you?

Community Support Team

## Re: Display values in 10 mins interval

Hi @Samrawit21,

You can try to use following measure which use firstnonblank function to filter these same value based on current type and time interval:

```First BodyValue =
CALCULATE (
FIRSTNONBLANK ( Append1[BodyValue], [BodyValue] ),
FILTER (
ALLSELECTED ( Append1 ),
[Type] = MAX ( Append1[Type] )
&& [TimeInterval] = MAX ( Append1[TimeInterval] )
)
)
```

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

For learning resources/Release notes, please visit: | |

Announcements

#### New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

#### Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

#### Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (2,298)