Line chart not displaying correctly - help!

[jnpb]

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!

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.

[Fowmy]

@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:

[jnpb]

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])

    )

)

[Fowmy · Accepted solution]

@jnpb 

I have modifed your measure, please try:

Cumulative Registration =
VAR SelectedProgram =
    SELECTEDVALUE ( 'DailyRegistrationCount'[Program] )
RETURN
    IF (
        SelectedProgram = "Swim"
            && NOT ISBLANK ( SUM('DailyRegistrationCount'[RegistrationCount]) ),
        [Weekly Cumulative Registration]
    )