cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
breadearner Frequent Visitor
Frequent Visitor

Pie Chart with Overlap

Hi everyone - is it possible to do a pie chart that shows overlap with different colors?

Let me explain what I mean:


I have a table laid out like this:

 

ID# | Program 1 | Program 2 | Program 3  | Program 4 | Program 5

 

so for example, a single person might show up in my data like this:

 

#777 |  No | No | No | Yes | Yes

 

When it's just a measure of who's in Program 1, it's easy. The problem occurs when I'm trying to show in a graph who also belongs to program 2 AND program 3, etc.

Is there a way to just show the graph with overlapping areas? I don't know of a good graph to do this with.


It seems like there should be a way to combine the columns, but I can't for the life of me find it. Ideally, it would show "Program 4&5" as the listing for the person's programs.

 

This is probably about as clear as mud but any help would be appreciated.

 

It doesn't have to be a pie chart, but I need to be able to show % of total on some type of readable graph, without having to click down 'layers' of a pie chart.

1 REPLY 1
v-cherch-msft Super Contributor
Super Contributor

Re: Pie Chart with Overlap

Hi @breadearner

 

It seems you may use 'Unpivot columns' for the data. And then create measures to get the count of overlap ID (Count of program>=2). Then you may get the percent measure and use it in pie chart or treemap chart. Show a simplified sample file here. If it is not your case, please explain more about your expected output. 

1.png

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 6 members 1,000 guests
Please welcome our newest community members: