Forum Discussion
Line chart with running total
Hello
I have a line chart dates from a Date table on the x-axis. I then have Culmative active engage on the Y Axis. I have a date filter on the visual which is set to Relative date is this month. The thing is the line is showing the same value for all the days in September apart from the 1st. Why is it doing this, it should only show values for 1st and 2nd September right?
Count of active engage = CALCULATE(COUNTX('Table','Table'[measure1]))
A quick a dirty way of dealing with this is create a measure that hides the calculation for days before today:
Hide values = If( selectedValue('Date'[Date]) <= Today(), [Culmative active engage], Blank())It would be better to work which of the 3 measures is returning the value regardless of filters. What is the definition of Measure1?
5 Replies
Hi SBR1D
If a measure CAN show data it will.
So a simple measure like:
Basic Measure = 1When in your visual will show for every single date available.
- Thanks, so it cannot be done?
A quick a dirty way of dealing with this is create a measure that hides the calculation for days before today:
Hide values = If( selectedValue('Date'[Date]) <= Today(), [Culmative active engage], Blank())It would be better to work which of the 3 measures is returning the value regardless of filters. What is the definition of Measure1?
