Forum Discussion

EAfang's avatar
EAfang
Frequent Visitor
10 years ago
Solved

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's avatar
    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.