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
richbenmintz's avatar
richbenmintz
Resident Rockstar
9 years ago

What value are you using for the slicer and how is it related to the filter and measure?

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????????