Forum Discussion

t-raatha's avatar
t-raatha
Regular Visitor
7 years ago
Solved

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'.