Use CompanyID in scatter chart, but shows Company name

[ylin88_waters]

Hello -

I'm using a scatter chart to show sales predition, real sales, with Company ID as "detail" to show the data for each ID (company site). When you hover the cursor over to the dot it shows Company ID, Sales and Sales prediction. But sales reps doesn't like to see company ID, because nobody remembers a Company ID. They want the scatter chart shows compmany name so they can find what they need. But I can't put Company Name to Detail because that changes the data - one company may have multiple sites with unique company IDs. If I put company name to Detail Power BI will sum up the sales by same company name and that's not what I want. I need to keep each dot on the scatter chart for each Company ID.

Is it posible that I use company ID to plot scatter chart, but shows company name instead? Thanks.

[lbendlin · Accepted solution]

Change the company name slightly for each ID (by appending periods or other tiny characters - Space will not work) to prevent the grouping in the visual.

[ylin88_waters]

Thanks!!!