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.
Hi,
I am trying to plot a scatter graph. Please see the data that I am working with below:
And this is how it plots:
When I add detail this is what I get:
As soon as I add detail the graph doesn't plot. Essentially I am aiming to add a cluster.
Does anyone have any idea as to why the graph is not plotting as it should when I add details?
What type of details are accepted in Power BI?
Thanks
Solved! Go to Solution.
Yes this is the error:
Can't display this visual.
Remove Details to display x- and y-axis pairs. Alternatively, you can keep Details and set a summarization for x- and y axis.
It worked now. What I did was I summarized the values for X and Y. When I set details as places it grouped the values together and summed them up. So there now is one plot for London which is (56,132). The two london points were added together. Notice that there are now only 4 points instead of 6.
The error message is self-explanatory, x-axis and y-axis must be summarized when you use Details field. That's to say, scatter chart is a visulization of summarized table grouped by Details, aggreation operation is to summarize x- and y-axis.
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
@HamidBee , can share the error details. There is a link on the error for that. Please share in text format
Yes this is the error:
Can't display this visual.
Remove Details to display x- and y-axis pairs. Alternatively, you can keep Details and set a summarization for x- and y axis.
It worked now. What I did was I summarized the values for X and Y. When I set details as places it grouped the values together and summed them up. So there now is one plot for London which is (56,132). The two london points were added together. Notice that there are now only 4 points instead of 6.
@HamidBee , Make sure both X and Y of number datatype , else you will not be able to use details
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 |
---|---|
106 | |
105 | |
79 | |
69 | |
62 |
User | Count |
---|---|
143 | |
104 | |
103 | |
82 | |
70 |