Pull data labels from adjacent column cells

[scottcrk]

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

[v-yalanwu-msft]

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.

[scottcrk]

Unfortunately this is not a solution.  I'll subit as an idea.