cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Samrawit21 Member
Member

Display values in 10 mins interval

 
11 REPLIES 11
themistoklis New Contributor
New Contributor

Re: Display values in 10 mins interval

@Samrawit21

 

This link will help you.

Community Support Team
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]
)

19.PNG

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, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI
Samrawit21 Member
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)

 

Capture.PNG

Community Support Team
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, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI
Samrawit21 Member
Member

Re: Display values in 10 mins interval

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

Community Support Team
Community Support Team

Re: Display values in 10 mins interval

HI @Samrawit21,

 

You can upload sample file to onedrive or google drive and paste share link here..

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI
Samrawit21 Member
Member

Re: Display values in 10 mins interval

Hi @v-shex-msft

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.

 

https://drive.google.com/open?id=1bjP99zYKt0H2HezA5r4b6MzkXrsw8NOs

Highlighted
Samrawit21 Member
Member

Re: Display values in 10 mins interval

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

Community Support Team
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] )
    )
)

7.png

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors