Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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
Can you share your pbix, very hard to diagnose this issue without know how the legend item and the other data points are related.
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
without the filter, no problem
What value are you using for the slicer and how is it related to the filter and measure?
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.
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????????
User | Count |
---|---|
82 | |
72 | |
67 | |
47 | |
36 |
User | Count |
---|---|
111 | |
56 | |
50 | |
42 | |
40 |