cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Alyssa212
New Member

How to separate and evaluate individividual values in a cell in a chart in Power BI

I have only seven items 'SA Lead, SE Lead, SA Engineer, SE engineer, RAM Lead, RAM Engineer, and HF'. But there are multiple items in one excel cell. I want to evaluate how many of each item are in the database. But the charts evaluate each cell and do not separate the items in one cell, so I ended up with dozens of items in the chart (see the screenshot of the pie chart below).

The original data can be seen in the screenshot of the list below. 

I wonder how I can evaluate individual items in charts.

Alyssa212_0-1669012826388.png

Alyssa212_1-1669012856295.png

 

1 ACCEPTED SOLUTION
PhilipTreacy
Super User
Super User

Hi @Alyssa212 

 

Download example PBIX file

 

You can split the column by delimiter, creating new rows.  Then trim the column to remove leading and trailing spaces from the values.  You get this

 

sply.png

 

What you do next is up to you.  You haven't' said how you want to 'evaluate individual items'.

 

You could create any chart you like and use a slicer to see individual items, but would it be more valuable to compare items against each other?

 

chrta.png

 

What exactly is the prupose of your analysis?  What do you want to learn from your data?

 

 

regards

 

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


View solution in original post

1 REPLY 1
PhilipTreacy
Super User
Super User

Hi @Alyssa212 

 

Download example PBIX file

 

You can split the column by delimiter, creating new rows.  Then trim the column to remove leading and trailing spaces from the values.  You get this

 

sply.png

 

What you do next is up to you.  You haven't' said how you want to 'evaluate individual items'.

 

You could create any chart you like and use a slicer to see individual items, but would it be more valuable to compare items against each other?

 

chrta.png

 

What exactly is the prupose of your analysis?  What do you want to learn from your data?

 

 

regards

 

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.

Top Solution Authors
Top Kudoed Authors