Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Two Legends on Scatter chart

Hi there,   I'm looking for a way to add a second legend to my scatter chart.    Currently I have my    X-Axis: TimeStamp  Y-Axis: Stats (Saving time)    My legend right now is set to be the...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    Anonymous - What about using the Size field? You could set N = 1 and Y = 2 for example in a measure

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , I doubt you have a secondary legend. Putting in another legend will remove the previous on.

 

But if the legend is not any additional data point. Means details are al line level and legend only doing color. Then you can try a measure to conditional formatting. Using "Field Value" option

 Like

color =
switch ( true(),
FIRSTNONBLANK('Table'[commodity],"NA") ="commodity1" && sum('Table'[Value]) >500,"lightgreen",
FIRSTNONBLANK('Table'[commodity],"NA") ="commodity2" && sum('Table'[Value]) >1000,"lightgreen",
// Add more conditions
"red"
)

 

But this will only work when legend so adds rows data. And you can not use a legend if you want conditional formating