Forum Discussion

NewInThis's avatar
NewInThis
Regular Visitor
4 years ago
Solved

DAX measure - chart with current time

Hi,  I have to present column chart that shows how many deliveries was done hourly.  The data that I am using will be refreshed evey hour.   I would like to show on the chart the period of 24 hour...
chart
DAX
measure
  • SpartaBI's avatar
    SpartaBI
    4 years ago

    NewInThis oh, so just add to your date table or whatever table you have the date column a flag column that checks for the last date and filter it by this. 
    If you don't succeed we can do a zoom call and I'll show you.

SpartaBI's avatar
SpartaBI
Icon for Community Champion rankCommunity Champion
4 years ago

NewInThis If you have a column of date and another column of the hour for each delivery then it is straightforward. It will be best practice anyway to have these in dimension tables but if you are very new and just need to plot it on a chart than just the columns are enough. Put both of them on the X axis and the meaure the counts the deliveries on the Y axis / value and you should get what you need (make sure to expand to next level the X axis to see both the dates and the hour.



In case it answered your question, please accept the solution to help other members find it. Appreciate Your Kudos.


SpartaBI Logo

Visit SpartaBI website   Visit SpartaBI Linkdin   Visit SpartaBI Facebook

Showcase Report – Contoso By SpartaBI

  • NewInThis's avatar
    NewInThis
    Regular Visitor
    4 years ago

    Thank you for the reply. Unfortunately this is not exactly what I need.
    The propsed solution gives me this:

     

    And I want this (please ignore red line):

     

     

    So I want to have view for only one day (24h), and it have to be the max date from the data.

     

    • SpartaBI's avatar
      SpartaBI
      Icon for Community Champion rankCommunity Champion
      4 years ago

      NewInThis oh, so just add to your date table or whatever table you have the date column a flag column that checks for the last date and filter it by this. 
      If you don't succeed we can do a zoom call and I'll show you.