Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Simple BoxPlot not showing in the R and Python Visuals

I am trying to create an R visual (boxplot) in my Power BI desktop app.  Here is a one liner from R that creates the boxplot:

 

boxplot(mpg~cyl,data=mtcars, main="Car Milage Data", 
   xlab="Number of Cylinders", ylab="Miles Per Gallon")

 

Note that this uses the built in mtcars dataset that is available out of the box with each R install.  this works fine in R and shows the boxplot.

 

Note that I know how to import this dataset into R/Python by going to Other sources and picking either R or Python Scripts.  For R as an example, I entered:

 

df <- mtcars

 

And connected to the datasource before proceeding to build the Visual.  I can see the fields belonging to this dataset in the 'query' pane and dragged the fields that I am interested in, i.e., mpg and cyl in the Values Box. Which makes them available in the "dataset" dataframe, so the aforementioned one liner becomes:

 

boxplot(mpg~cyl,data=dataset, main="Car Milage Data", 
   xlab="Number of Cylinders", ylab="Miles Per Gallon")

 

However, when I try to show it as an R Visual Custom control, all I get is a line within a frame and no boxes.  My desktop is the latest October release of Power BI (2.63.3272.40461 64-bit (October 2018)

 

I get no error messages.  Same thing is happening to the Python Seaborn boxplots.

 

Please advise.

 

Thanks.

 

Bharat

1 ACCEPTED SOLUTION
Anonymous
Not applicable

I figured it out.  Any numeric variable that you are trying to plot must have 'Do not Summarize' checked instead of 'Sum' which Power BI does by default.  Once I did that, the boxplot appeared fine.  I think that the default in Power BI must be changed.

View solution in original post

2 REPLIES 2
v-yulgu-msft
Microsoft Employee
Microsoft Employee

Hi @Anonymous,

 

Did you get a blank visual with above R code on report page? Can you show us a screenshot of result? Also, please test the sample in this blog to see if it works.

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

I figured it out.  Any numeric variable that you are trying to plot must have 'Do not Summarize' checked instead of 'Sum' which Power BI does by default.  Once I did that, the boxplot appeared fine.  I think that the default in Power BI must be changed.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.