How to show and count different values in one row

[Maryam_Pour]

Hi there,

I hope you can help me with this issue.
I have a column called Project and some rows showing multiple projects. Please see below:

I want to have a bar chart showing all projects separately.
How can I do that?

[amitchandak · Accepted solution]

@Maryam_Pour , better to split data in power query by comma into rows

https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/

[Maryam_Pour]

Now I got what you mean Amit 🙂 

There was an option to select between split to Columns or Rows unders Advanced options:

**never noticed that before 😞 

Thanks 🙂

[Maryam_Pour]

Hi Amitchandak,
Thanks for your response. I know how to split the data into new columns. By splitting into the new columns, I will have 4 columns for showing my projects, and I just need to have one column called Project to use in the bar chart.