Forum Discussion

PowerbiGuRoo's avatar
PowerbiGuRoo
Icon for Advocate I rankAdvocate I
6 years ago

The ability for Line Chart to include dates <= Slicer Value

I have a drop down list that can select only one date.  All the visuals on the page filters based on that one date.  The Line Chart visual ignores the slicer.  The dataset never truncates.  It captur...
DAX
power bi
Anonymous's avatar
Anonymous
Not applicable
6 years ago
One cannot tell anything about how to solve this unless one knows the underlying model...

Best
D
  • PowerbiGuRoo's avatar
    PowerbiGuRoo
    Icon for Advocate I rankAdvocate I
    6 years ago

    The Model contains all the prior records and current records for each day.  The line chart is ignoring the Date Slicer.  It totals the row count for each day.  This is working fine.  Now, if someone selects March 9th, I want the line chart to only show the dates <= March 9th.  Even though there are additional dates 10th, 11th, 12th.... Show 5th, 6th, 7th, 8th, and stop at the 9th.