Forum Discussion
Pie Chart Question
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.
Hello,
We figured it out. We created additional columns in power query using if statement formula and added those columns to the pie chart.
4 Replies
You can get a result like this...
by splitting the policy column into new rows.
I have attached an example pbix.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.
Hello,
We figured it out. We created additional columns in power query using if statement formula and added those columns to the pie chart.
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.
