Forum Discussion
Chris1300
4 years agoHelper II
Data changing when adding legend
I have a column chart that shows running total of distinct Login by week date. I then add a legend to the same chart but the distinct count CHANGES (see total values above column). I am unable to...
wesleygeddes555
3 years agoNew Member
I have been experiencing the exact same issue.
Here is the measure:
Number of Issues during the Period =
VAR EndDatePerVisual = MAX('Date'[Date])
VAR StartDatePerVisual = MIN('Date'[Date])
VAR RESULT =
CALCULATE(
[Number of Issues],
REMOVEFILTERS('Date'),
Issues[Start Date] <= EndDatePerVisual,
Issues[Due Date] > StartDatePerVisual || ISBLANK(Issues[Due Date])
)
RETURN RESULTIt's really easy to visualize this problem when using a "Line and clustered column chart:
The configuration of this visual is here:
The measure being stored in "Column y-axis" is the SAME measure in the "Line y-axis." But yet the total value for the line and the columns are different.
LazyBanker
2 years agoNew Member
Were you able to figure out the difference? I'm experiencing a similar issue.