Forum Discussion
Legend Displaying differently on PowerBI Desktop and PowerBI Service
I was working on a custom visual using R and plotly to render a graph with multiple Y-Axes. I can see the legend as I expect to see it when I'm authoring a report on PowerBI Desktop. But I can't see the legend as I expect it in PowerBI Service when I try publishing it. I suspect it has something to do with this line of code in R, but I'm not sure:
paly1 = c("red","green")
p = plot_ly() %>%
add_lines(x = Values$Time, y = Values$ActualValues, name = paste(Values$name, "(", names(Values$name)[1], ")", " "), colors = ~paly1)
In this scenario, Values is a dataRole that will definitely have a 'Time' column with various timestamps for the X-Axis, an 'ActualValues' column to be plotted along the Y-Axis, and a 'name' column for the legend. The name is something the user can filter.
So on Desktop this is how I see the legend (as expected):
Value$name consists of all these rows.
But in PowerBI Service, I end up seeing:
And the 5 lines that are supposed to be plotted also all look blue in color.
How could I fix this?
In case anyone runs into this issue as well, try manipulating the 'color' field in plotly instead of 'names'.