Visual chart for data by minute, but only having the time periods

[Fabian_Carvajal]

Hi guys,

I have a report with data from 7am to 7am which is fed with time intervals with different values, not a minute by minute value.

Actually I make this chart with excel

using the data scructured this way

*Both images are not related (different dates)

So I'm trying to do this excel report in PowerBI but i'm getting this

when it should look like this 

**These two images are related (data from the same day)

In powerbi i'm using the date and hour value for the X axis and the value for Y axis. 

I already saw this video

Power BI | Time Based Charts | Time Visualization Using Power BI

but i need the data organized minute by minute and I dont know how to create rows and repeat the values until it reaches the next period of time

Any ideas on how to continue with this or solve it with a different approach?

Thanks for your time!

[Anonymous · Accepted solution]

Hi @Fabian_Carvajal ,

Based on your description, I created these data.

Create the calculation table.

date = VALUES('Table'[DateTime])

Create the measure.

MEASURE = 
IF (
    (
        DAY ( MAX ( 'Table'[DateTime] ) ) = DAY ( MAX ( 'date'[DateTime] ) )
            && HOUR ( MAX ( 'Table'[DateTime] ) ) >= 7
    )
        || (
            DAY ( MAX ( 'Table'[DateTime] ) )
                = DAY ( MAX ( 'date'[DateTime] ) ) + 1
                && HOUR ( MAX ( 'Table'[DateTime] ) ) <= 7
        ),
    SUM ( 'Table'[Value] ),
    BLANK ()
)

More details can be found in the attachment.

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

[Greg_Deckler]

@Fabian_Carvajal Take a look at this approach and see if it fits the need. https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364#M147

Otherwise, Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.