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.

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.