Forum Discussion

BennyS's avatar
BennyS
New Member
2 years ago
Solved

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:

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!

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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: 

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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: