Data Preparation in PowerBI or in Python upfront?

[BennyS]

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:

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

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!

[Anonymous · Accepted solution]

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: