Forum Discussion

Noak's avatar
Noak
Icon for Helper IV rankHelper IV
9 years ago

Bar chart time referance

Hi,

currently Im working on big cloud project using your platform .

have some issues with the bar chart, my data includes:

X: Incoming message every 5 minutes .

y: AVG sum messages .

 

 

I would like to present msg only for past hour from NOW, and (if I can) to draw a line  as shows in the image (I would like to emphesis "Current" time on the line chart)..

 

 

 

please help me.

thank you!.

 

 

 

 

looking for solution

 

 

 

 

Need Help

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    9 years ago

    You should be able to create a calculated column like:

     

    HoursAgo = DATEDIFF([Date],NOW()),HOUR)

    Then filter your chart by this column.

    • Noak's avatar
      Noak
      Icon for Helper IV rankHelper IV
      9 years ago

      Hi Greg_Deckler v-caliao-msft,

      thank you for your help still having issues.

      the PBI dont know to seperate different hourse at the same date.

      lets say today 28/11 and yasterday was the 27/11 :

      27/11 13:00 Hourse ago =24

      27/11 12:00 Hourse ago =24

       

      please via attached.

      your help appriciated!.

       

  • v-caliao-msft's avatar
    v-caliao-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi Noak,

     

    Add a calculated colume by using the DAX below.
    Type = IF(DATEDIFF(Sheet7[DateTime],NOW(),MINUTE)<=60,"Latest Data","History Data")

    Then add this new created column to a slicer visual.

     

    Regards,

    Charlie Liao