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.
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.
Solved! Go to 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.
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.
Thanks!!!
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 |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |