Forum Discussion
Axis are not displaying properly in Power BI services for HTML R Custom visual
Hi All,
We have built a HTML R Custom visual. This componet is working fine in the Power BI desktop, however same componet get messed up in axis when we publish it to the Power BI service.
Please have a look at following screen shot. We have same problem in all the components which are in the production app. Looks like problem started after last update of Power BI service in Nov 2020.
Sample R HTML code
source('./r_files/flatten_HTML.r')
############### Library Declarations ###############
libraryRequireInstall("ggplot2");
libraryRequireInstall("plotly");
libraryRequireInstall("XML");
libraryRequireInstall("dplyr");
libraryRequireInstall("reshape2")
####################################################
dataset <- Values
g<-ggplot(data = dataset, aes(x=as.Date(Date), y=Reason, label = Time ))
####################################################
############# Create and save widget ###############
p = ggplotly(g);
internalSaveWidget(p, 'out.html');
####################################################
Sample data
Time ShortName Reason Date
D Response to 31/05/2019 0:00
31 D Issued 15/04/2019 0:00
D Return 12/06/2019 0:00
B Return 9/11/2018 0:00
C Return 11/02/2019 0:00
C Return 13/03/2019 0:00
D Return 2/07/2019 0:00
A Return 23/09/2019 0:00
D Response to 20/06/2019 0:00
10 D Return 11/06/2019 0:00
21 D Return 2/05/2019 0:00
54 A Return 8/07/2019 0:00
1 A Issued Outside 5/07/2019 0:00
1 A Issued Outside 20/09/2019 0:00
5 D Response to 25/06/2019 0:00
6 D Response to 31/05/2019 0:00
9 C Issued 29/01/2019 0:00
10 D Issued 15/04/2019 0:00
A Issued Outside 20/09/2019 0:00
D Response to 31/05/2019 0:00
10 D Issued 15/04/2019 0:00
55 A Issued Outside 5/07/2019 0:00
2 Replies
- AnonymousNot applicable
Hi,
Hope these help.
https://community.powerbi.com/t5/Service/R-Visual-not-working-in-PBI-services/m-p/781173#M75447
https://community.powerbi.com/t5/Desktop/Charts-to-display-Dates-and-items/td-p/83165
https://community.powerbi.com/t5/Desktop/Charts-to-display-Dates-and-items/td-p/83165
Best Regards,
Eyelyn Qin - AnonymousNot applicable
Hi Rohit_PBI ,
Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it.
Best Regards,
Eyelyn Qin