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

Can you share your pbix, very hard to diagnose this issue without know how the legend item and the other data points are related.

  • raffbr2's avatar
    raffbr2
    Frequent Visitor
    9 years ago

    I can but will take time but have a look. With an extra filter in a differen column i have the issue

     

    The filter is a simpler slide - let me know if you can figure out -if not I ll sent the file

     

     

     

    without the filter, no problem

     

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