Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
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.
Regards,
Cherie
User | Count |
---|---|
91 | |
73 | |
68 | |
63 | |
55 |
User | Count |
---|---|
99 | |
88 | |
73 | |
60 | |
58 |