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
BennyS
New Member

Data Preparation in PowerBI or in Python upfront?

Hi Community!

 

I am currently starting my "PowerBI Career" and I guess I need some starting push. 

The result of my python script that collects data is a CSV file which is uploaded to a database table. I want to create a PowerBI Dashboard for that data. 

 

That table contains e.g. a column which looks as follows:

Column_Example1.png

I want to create a barchart thereof which looks like this.

BarChart_Example1.png

 

I realized that I can do this with a "split column by delimiter" to rows. However, this deteriotates the table itself for other visualisation that I am planning. Is there a way to get this visualisation by not splitting the column? In Tibco Spotfire I would imagine a code snippet in the y-axis definition. 

 

I also would like to do other transformations like this.

 

Any starting advice? 🙂 

 

Thanks a lot!

1 ACCEPTED SOLUTION
KriZo
Resolver II
Resolver II

You could do a Python visual:

 

import seaborn as sns
import pandas as pd
import matplotlib.pyplot as plt

all_values = ','.join(dataset['Column1']).split(',')

sns.countplot(y=all_values
plt.show()

 

 Which would result in: 

KriZo_0-1711552719718.png

View solution in original post

1 REPLY 1
KriZo
Resolver II
Resolver II

You could do a Python visual:

 

import seaborn as sns
import pandas as pd
import matplotlib.pyplot as plt

all_values = ','.join(dataset['Column1']).split(',')

sns.countplot(y=all_values
plt.show()

 

 Which would result in: 

KriZo_0-1711552719718.png

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.