Forum Discussion
Pull data labels from adjacent column cells
Hi,
I'm trying to recreate a chart in PowerBI that is simple to create in Excel. The data table looks like this:
| NSF Fine Field Disciplines | Average 2016-2020 NSF Non-White PhD Grads | 2021 Non-White Headcount | Practice(s) | 2021 Non-White Headcount | Practice(s) | 2021 Non-White Headcount | Practice(s) |
| Geosciences, atmospheric, and ocean sciences | 19% | 11% | Enviro | 5% | Eco | ||
| Physics | 23% | ||||||
| Agricultural sciences and natural resources | 23% | ||||||
| Aerospace, aeronautical, and astronautical engineering | 26% | ||||||
| Chemistry | 26% | 28% | PSMC | 21% | CRFS | ||
| Cognitive psychology and neuroscience* | 27% | 22% | HF | ||||
| Mechanical engineering | 28% | 22% | ME | 20% | Thermal | 11% | Vehicle |
| Mathematics and statistics | 29% | 34% | DS | ||||
| Nutrition sciences | 29% | ||||||
| Civil engineering | 31% | 27% | Civil | 28% | B&S | 35% | Construction |
| Chemical engineering | 33% | ||||||
| Computer and information sciences | 33% | ||||||
| Materials science engineering | 34% | 20% | MCE | ||||
| Epidemiology and Toxicology | 36% | 26% | Health | ||||
| Bioengineering and biomedical engineering | 39% | 24% | Biomech | 40% | BMES | ||
| Electrical, electronics, and communications engineering | 40% | 34% | EECS | ||||
| Total | 29% | 24% | All US Consultants |
The Excel chart looks like this:
I am able to come close to recreating this in PowerBI as follows, but I cannot figure out how to add the text labels to the markers from the columns in the table next to the data points. In Excel you simply set the data label to value from a group of cells. But I don't see any way to do this in PowerBI. Is it not possible?
Ideas are much appreciated.
Sally
2 Replies
v-yalanwu-msftCommunity Support
Hi, scottcrk ;
s I know, the data label is based on value, so we could not use custom label or use text in label. You could use this in tooltip. By the way, I suggest you could submit this in power-bi-ideas .
Or you could try this custom visual.
Solved: Power BI - Visuals that support custom data labels... - Microsoft Power BI Community
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Unfortunately this is not a solution. I'll subit as an idea.
