Pie Chart Question

[gmasta1129]

Hello,

I am having trouble creating a pie chart. 

My table contains two columns

1. Facility Code

2. Policy #

Facility Code       Policy #

12345                    1

54321                    1&2

64589                    2&4&3

21180                     5&3

90612                     1

I would like to put this in a pie chart where it shows ex: Two facilities are under policy #2, One facility is under policy #4, Three facilities are under policy #1 and Two facilities are under policy #2. The issue is when a facility code contains more than one policy number.  We tried to split the columns but that did not work either.  Is this even possible to do? 

Thanks in advance. 

[v-aatheeque]

Hi @gmasta1129 

We wanted to follow up to check if you’ve had an opportunity to review the previous responses. If you require further assistance, please don’t hesitate to let us know.

[gmasta1129 · Accepted solution]

Hello, 

We figured it out.  We created additional columns in power query using if statement formula and added those columns to the pie chart. 

[jgeddes]

You can get a result like this...

by splitting the policy column into new rows. 
I have attached an example pbix.

[v-aatheeque]

Hi @gmasta1129 

Have you had a chance to look through the responses shared earlier? If anything is still unclear, we’ll be happy to provide additional support.