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.
Dear All,
I am using a scatter chart, whereby as 'Values' I use customers, as X Axis 'Profits', and as Y Axis 'Net Sales'.
I want do add a third calculated measure (Avg. Profits % for Product Category) to X Axis.
In the end, I would want to see both the 'Profits' for the particular customer and the average profits for the corresponding product groups.
Any help, suggestion, or tip would be greatly appreciated.
Have a wonderful weekend!
Solved! Go to Solution.
Hi @Giorgi1989 ,
Just as amitchandak said, you couldn’t use two Measures on x-axis, otherwise, you will receive the following error. To make this visual display properly, you need regulate fields as the error prompted.
Per the description, create the Scatter chart like the following would be a good choice.
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. Thanks in advance!
Best Regards,
Community Support Team _ Caiyun
Hi @Giorgi1989 ,
Just as amitchandak said, you couldn’t use two Measures on x-axis, otherwise, you will receive the following error. To make this visual display properly, you need regulate fields as the error prompted.
Per the description, create the Scatter chart like the following would be a good choice.
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. Thanks in advance!
Best Regards,
Community Support Team _ Caiyun
@Giorgi1989 , You can not use 2 measures on x-axis , but you can use one as a size
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 |
---|---|
49 | |
26 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |