cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Problem with line graph

Hello

 

I have the following graph with no legend:

 

s1.png

And this the same graph with added Legend

s2.png

Why is that happening? This is wrecking my dashboard

 

6 REPLIES 6
Highlighted
Solution Sage
Solution Sage

Re: Problem with line graph

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

Highlighted
Frequent Visitor

Re: Problem with line graph

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

 

 

s3.png

 

without the filter, no problem

 

s4.png

Highlighted
Solution Sage
Solution Sage

Re: Problem with line graph

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

Highlighted
Frequent Visitor

Re: Problem with line graph

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

Highlighted
Solution Sage
Solution Sage

Re: Problem with line graph

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

Highlighted
Frequent Visitor

Re: Problem with line graph

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

 

s5.png

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors