Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I'm trying to create a Venn Diagram with the similar data example. My actual data ia referenced from 2 other tables. I'm hoping to achieve the end result in the 2nd picture in data format- so as to able to put into Venn Diagram to show the overlapping materials.
I've tried Group By and Pivot Column. The problem is Group By will take away some of the referenced columns that I would like to show. Pivot Column will not remove the duplicates in Material column...
Is there any way I can pivot in a way that I can show it in Venn Diagram, and have the Visual 'Table' next to it, so I can click a series of Materials, and the Venn can show the overlaps?
Solved! Go to Solution.
Hi FuzzyWazzy,
To achieve your requirement, click Query Editor-> Transform-> Pivot Column as below:
Regards,
Jimmy Tao
Hi FuzzyWazzy,
To achieve your requirement, click Query Editor-> Transform-> Pivot Column as below:
Regards,
Jimmy Tao
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |