Forum Discussion
Line chart not displaying correctly - help!
Hi all,
I've been fighting with a line chart visual for two weeks and am entirely confounded as to what the problem is with the results. The goal is: show the cumulative number of event registrations for 2023 (all) and 2024 (YTD) so that we can analyize our performance vs last year.
After taking feedback from my previous attempt, I have:
-Created a consolidated view in the database that contains all of the event registrations for multiple years (2023, 2024) and includes the dates.
- Created a date table
I've setup the line visual in the following way:
X-Axis: MonthName (January-December)
Y-Axis: Cumulative Registration Measure (shown below)
Legend: Year
The measure in the Y-Axis is:
Cumulative Registration =
VAR SelectedProgram = SELECTEDVALUE('DailyRegistrationCount'[Program])
RETURN
IF(
SelectedProgram = "Swim",
CALCULATE([Weekly Cumulative Registration], 'DateTable'[Month] <= 12), // January to December
[Weekly Cumulative Registration] // Full Year
)
The line for 2023 shows correctly (cumulatively), but the line for 2024 - despite having data and the value reporting correctly, shows a flat trend line that extends across Jan-Dec despite it only being January 13.
This is the current, output that displays incorrectly:
I'm losing my darned mind! What am I doing incorreectly that is causing the line to extend past the current date and also be flat? Any insight you have would be immensely appreciated.
Thank you!
4 Replies
jnpb
since you have the year in the legend, the measure should be as follows:Cumulative Registration = VAR SelectedProgram = SELECTEDVALUE ( 'DailyRegistrationCount'[Program] ) RETURN IF ( SelectedProgram = "Swim" && NOT ISBLANK ( [Sum of Registration Measure] ), [Weekly Cumulative Registration] )
Or, If you want restrict the cumulative sum being shown where there is not data try this:I'm a bit confused by the [Sum of Registration Measure] part. This is what I have as my 'Weekly Cumulative Registration' measure:
Weekly Cumulative Registration =CALCULATE (SUM('DailyRegistrationCount'[RegistrationCount]),FILTER (ALL('DateTable'),'DateTable'[Year] = MAX('DateTable'[Year]) &&'DateTable'[WeekOfYear] <= MAX('DateTable'[WeekOfYear])))
Hi,
Share the download link of the PBI file.
