Forum Discussion

lowdman87's avatar
lowdman87
Frequent Visitor
2 years ago
Solved

Future dates showing in chart when future dates do not exist in the table.

Hello, I have a chart I am displaying with the Date on the X-axis and a aggregated value (from a measure) on the y-axis.  I am using a Date table for my date.  The current date is 9/5/24.  Date Table...
Need Help
  • amitchandak's avatar
    amitchandak
    2 years ago

    lowdman87 , make sure you have not used the option "Show Item with no Data" on right click on date hierarchy

     

     

    Or you can have measures to control

     

    Remove outside range  =
    var _min = minx(ALLSELECTED(Table), Table[Date])
    var _max = maxx(ALLSELECTED(Table), Table[Date])
    return
    if(max('Date'[Date])>=_min && Max('Date'[Date]) <=_max, [Your Measure] BLANK())

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

lowdman87 , make sure you have not used the option "Show Item with no Data" on right click on date hierarchy

 

 

Or you can have measures to control

 

Remove outside range  =
var _min = minx(ALLSELECTED(Table), Table[Date])
var _max = maxx(ALLSELECTED(Table), Table[Date])
return
if(max('Date'[Date])>=_min && Max('Date'[Date]) <=_max, [Your Measure] BLANK())

lowdman87's avatar
lowdman87
Frequent Visitor
2 years ago

Thanks.  I did not have the "Show items with no data" checked, but the measure did resolve my issue.  Thank you.