Forum Discussion

raffbr2's avatar
raffbr2
Frequent Visitor
9 years ago

Problem with line graph

Hello   I have the following graph with no legend:   And this the same graph with added Legend Why is that happening? This is wrecking my dashboard  
Need Help
raffbr2's avatar
raffbr2
Frequent Visitor
9 years ago

Unrelated... the slide measure is not used on the measure (below) - the only difference between the correct graph and the messy one is that I removed the slide on a column that is not used on the measure.

 

ScoreTot =
CALCULATE (
(sumX(FILTER(Dados, Dados[resultado]="a"),Dados[Numrec]*[PesoAcordo])-
sumX(FILTER(Dados, Dados[resultado]="p"),Dados[Numrec])+
sumX(FILTER(Dados, Dados[resultado]="i"),Dados[Numrec])-
sumX(FILTER(Dados, Dados[resultado]="r"),Dados[Numrec])+
sumX(FILTER(Dados, Dados[resultado]="e"),Dados[Numrec])
)/sum(Dados[NumRecords]),
FILTER(ALL ( Dados[dataMovIni] ),
Dados[dataMovIni] <= MAX ( Dados[dataMovIni] ) )
)

richbenmintz's avatar
richbenmintz
Resident Rockstar
9 years ago

My guess is that the slice value is effecting the filter context of your measure.

  • raffbr2's avatar
    raffbr2
    Frequent Visitor
    9 years ago

    I did a calculated column when 1 is for values > 10000 and  0 for less.  It worked - 

     

    **bleep**, how come a slices is different than a calculated column????????