Python Visualisation - Horizontal Bar Chart

[kilala]

Hi all, I'm a beginner in both python and power bi. I am trying to do horizontal bar chart in power bi but using python script. In my visualisation, sales will act as x-axis and subcategory will act as y-axis. However, the graph i made did not show the value for the sales(it looks weird). It did not start from 0 and the length of each data is not displayed.

This is my coding:

import matplotlib.pyplot as plt
import pandas as pd

data = dataset.Sales
df = pd.DataFrame(data,columns=[dataset.Sales], index =[dataset.Sub_Category])

df.plot.barh()
plt.title("Sales by Subcategory")
plt.ylabel("Sub_Category")
plt.xlabel("Sales")
plt.show()

I tried to search online but there are no tutorial that specific for python in power bi, so I'm confused. Hope the expert can helps me:)

[v-yingjl]

Hi @kilala ,

Although I am not an expert in python, I think these documents and video below may be helpful to you about creating python visuals in power bi desktop:

1. Create Power BI visuals by using Python 
2. Using Python Visuals in Power BI 
3. Power BI - Introduction to Python Visuals 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PhilipTreacy]

Hi @kilala 

Please supply your dataset as a file
Phil