Forum Discussion

jnpb's avatar
jnpb
Helper I
2 years ago
Solved

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 registra...
Need Help
  • Fowmy's avatar
    Fowmy
    2 years ago

    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]
    )
Fowmy's avatar
Fowmy
Super User
2 years ago

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's avatar
    jnpb
    Helper I
    2 years ago

    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's avatar
      Fowmy
      Super User
      2 years ago

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