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