Line Graph with 10 Minute Intervals on x-axis

Hello Power BI Users Please I started working on a personal IT project that uses Power BI to create dashboards. I want to create a line graph with 10 minutes intervals that shows a plot of KPI like...

Eric_Zhang

10 years ago

EAfang

Create another calculated column

Setup Time2 =
DATE ( YEAR ( 'BI Folder'[Setup Time] ), MONTH ( 'BI Folder'[Setup Time] ), DAY ( 'BI Folder'[Setup Time] ) )
    + TIME ( HOUR ( 'BI Folder'[Setup Time] ), FLOOR ( MINUTE ( 'BI Folder'[Setup Time] ), 10 ), 0 )

And an extra measure

ASR in last 10 mins = CALCULATE(DIVIDE (SUM ('BI Folder'[Answer Status]), COUNTA('BI Folder'[Session Status])),LASTNONBLANK('BI Folder'[Setup Time2],""))

If it answers your question, please accept it as answer. For any question, feel free to let me know.

EAfang

Frequent Visitor

10 years ago

Eric_Zhang

Thank you! Thank you!! & Thank you!!!

In fact I'm loving Microsoft even more for a community like this.

You sure have answered my primary question and I have accepted your last post as the solution. But please is there a way to view the second to last ASR value (46.86%) on the CARD VISUAL instead of the last [ongoing] ASR (33.44%)?

Calculate Lastnonblank