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 have a table that contains the following columns:
Column A - Name
Column B - Region
Column C - Skill Set
In column C, more than one skill can be attributed to the individual. For example one record could read 'project management', another could read 'project management, stakeholder management', and another could read 'stakeholder management, data analysis, Excel.'
Is there a way to create a donut chart to display all distinct comma separated values in Column C, so that each possible skill is displayed? So far, I can only get a donut chart to display every combination that appears.
Thanks
Solved! Go to Solution.
Hi @shaunguyver,
Maybe you can add calculated column with CONCATENATEX function to manually summary project names with comma, then use this column as category of donut chart.
Regards,
Xiaoxin Sheng
Hi @shaunguyver,
Maybe you can add calculated column with CONCATENATEX function to manually summary project names with comma, then use this column as category of donut chart.
Regards,
Xiaoxin Sheng
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 |
---|---|
108 | |
106 | |
87 | |
77 | |
69 |
User | Count |
---|---|
124 | |
112 | |
94 | |
84 | |
75 |