Trend Line

[cborde3]

Hello,

I work for a utility and am trying to create a 24 Rolling Hour Historigraph graph showing outage restoration with a trendline showing remaining outages:

    

Fig. 1  Sample Data (Outage Start and End Times)

Fig. 2  24 Hour Historigraph for outage restoration.

I'm trying to showing remaining outages trend along with restorations.  I'm fairly new to PBI so please bear with me.

Thanks

[v-kkf-msft]

Hi @cborde3 ,

I am not sure if I understood your question correctly. Do you want to use the Trend line in the Power BI analysis pane?

Then you can use it in the following visuals.

The following visuals can use a trend line if there's time data:

• Area chart
• Clustered column chart
• Line chart
• Line and clustered column chart
• Scatter chart

For more information, please refer to: Use the Analytics pane in Power BI Desktop 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@cborde3 , Try a measure like

calculate(countrows(Table), filter(Table, Table[Tourbal clear time] >=now()-24  && Table[Tourbal clear time] <= now()) )

[cborde3]

Thank you for the reply.  I'm receiving the following error: