Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Display data after every 30 mins

   Please help This data below is in every 5mins. Please I want the data to display every 30mins. Please What column or measure or expression to achieve this??    
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    9 years ago

    Hi Anonymous,

     

    As a workaround, rather than creating a calculated table where date/time displays every 30 minutes, please add two calculated columns in original table 'A2011_ConfigData'.

    Minute diff =
IF (
    MINUTE ( FORMAT ( A2011_ConfigData[DataTimePrevious], "hh:mm:ss" ) ) < 30,
    30 - MINUTE ( FORMAT ( A2011_ConfigData[DataTimePrevious], "hh:mm:ss" ) ),
    60 - MINUTE ( FORMAT ( A2011_ConfigData[DataTimePrevious], "hh:mm:ss" ) )
)

every 30 minutes =
SWITCH (
    A2011_ConfigData[Minute diff],
    5, A2011_ConfigData[DataTimePrevious] + TIME ( 0, 5, 0 ),
    10, A2011_ConfigData[DataTimePrevious] + TIME ( 0, 10, 0 ),
    15, A2011_ConfigData[DataTimePrevious] + TIME ( 0, 15, 0 ),
    20, A2011_ConfigData[DataTimePrevious] + TIME ( 0, 20, 0 ),
    25, A2011_ConfigData[DataTimePrevious] + TIME ( 0, 25, 0 ),
    30, A2011_ConfigData[DataTimePrevious] + TIME ( 0, 0, 0 )
)

     

    Add 'A2011_ConfigData'[DataValueDelta] and 'A2011_ConfigData'[every 30 minutes] to your line chart.

     

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
9 years ago

Hi Anonymous,

 

What do you mean the calculated table does not responding to other charts, it doesnt respond appropriately like the original 5minutes chart data do? Do you mean the chart based on the calculated table doesn't show data conditionally according to the selection from slicer?

 

Based on my test, it did respond to the slicer selection, you coule see the difference from below screenshot. You can set the value range on Y-axis to a smaller value so that you can see the difference more clearly.

 

Regards,
Yuliana Gu

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

     Solved

     

     

     

    • v-yulgu-msft's avatar
      v-yulgu-msft
      Microsoft Employee
      9 years ago

      Hi Anonymous,

       

      As a workaround, rather than creating a calculated table where date/time displays every 30 minutes, please add two calculated columns in original table 'A2011_ConfigData'.

      Minute diff =
IF (
    MINUTE ( FORMAT ( A2011_ConfigData[DataTimePrevious], "hh:mm:ss" ) ) < 30,
    30 - MINUTE ( FORMAT ( A2011_ConfigData[DataTimePrevious], "hh:mm:ss" ) ),
    60 - MINUTE ( FORMAT ( A2011_ConfigData[DataTimePrevious], "hh:mm:ss" ) )
)

every 30 minutes =
SWITCH (
    A2011_ConfigData[Minute diff],
    5, A2011_ConfigData[DataTimePrevious] + TIME ( 0, 5, 0 ),
    10, A2011_ConfigData[DataTimePrevious] + TIME ( 0, 10, 0 ),
    15, A2011_ConfigData[DataTimePrevious] + TIME ( 0, 15, 0 ),
    20, A2011_ConfigData[DataTimePrevious] + TIME ( 0, 20, 0 ),
    25, A2011_ConfigData[DataTimePrevious] + TIME ( 0, 25, 0 ),
    30, A2011_ConfigData[DataTimePrevious] + TIME ( 0, 0, 0 )
)

       

      Add 'A2011_ConfigData'[DataValueDelta] and 'A2011_ConfigData'[every 30 minutes] to your line chart.

       

      Best regards,

      Yuliana Gu