Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
raffbr2
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
richbenmintz
Solution Sage
Solution Sage

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



I hope this helps,
Richard

Did I answer your question? Mark my post as a solution! Kudos Appreciated!

Proud to be a Super User!


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

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



I hope this helps,
Richard

Did I answer your question? Mark my post as a solution! Kudos Appreciated!

Proud to be a Super User!


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

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



I hope this helps,
Richard

Did I answer your question? Mark my post as a solution! Kudos Appreciated!

Proud to be a Super User!


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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.