Link a column with text and a value together to create a chart

[Mouseman85]

Hi, 

I'm fairly new to Power Bi and have been tasked in creating a report for our 209 counties use a preset excel that can't change, as each area will need to update that excel, we where currently using excel to generate charts embedding them in powerpoint and exporting but this method is to time consuming and we now need to template each area, which would mean 209 templates, hence Power Bi.

I've got some basic functions working, but what i need to do is take the below data layout and display it as per the chart from excel but i can't figure out how to do this in power bi:

If you can tell from the above image, i have a master Market the first column and then inside each market, is search market, each search market then has a percentage mrkt as the search results. The above chart from Excel, links each search market to the market percetnage to display that value, but i can't see how to do that in power bi, or how i would even need to change the data layout to make it work, does anyone have any suggestions as it seems like a fairly simple thing to do but due to my lack of knowledge i'm struggling, and i'm not sure what to google.

Thanks

[PhilipTreacy]

Hi @Mouseman85 

Any chance you can share the data as a file or copy/paste it?  Really hard to work with an image of the data and have to recreate it all.

Thanks

Phil

[Mouseman85]

Hi Phil,

Here is a link below - https://we.tl/t-w0mwu50fUD 

i'm really stuck with it, it seems like power bi is the perfect solution for what we need to do, but maybe the data needs laying out differently?