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'm struggling to display many data points within the same category (x-axis). In the last few days, I've try with the line chart first, then I attempt to make it work with 5 custom visuals downloaded from the market place... then I got near the desired result with the Scatter plot.
Scenario :
Power BI does not allow me to put the GroupNumber on the Detail value.
When using the Legend I get the right level of details BUT ... I don't want all those colors, they are irrelevant.
Since group numbering varies a lot, it's impossible to manually update the color for each individual legen items.
And... I'd like to use the Legend to identifty the teacher.
Any idea how I can do it?
Thanks
--mo
Solved! Go to Solution.
Hi @molegris ,
As tested here,if you wanna keep both details , X- and Y- axis,you should change all the values of the three fields to "whole number":
If X-axis is text format,you would see:
If X-axis is whole number,you would see:
So I have a workaround for you:
Create 2 columns as below:
Column = RIGHT('Table'[X],4)
rankx = 'Table'[Column]&RANKX(FILTER('Table','Table'[Column]=EARLIER('Table'[Column])),'Table'[X],,ASC,Dense)
Then you would see the 2 additional columns in your table such as below:
Change the column "rankx" to whole number and put it in X-axis,you will see:
You could also check the reference below :
https://www.tutorialgateway.org/scatter-chart-in-power-bi/
For my sample .pbix file,pls see attached.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Hi @molegris ,
As tested here,if you wanna keep both details , X- and Y- axis,you should change all the values of the three fields to "whole number":
If X-axis is text format,you would see:
If X-axis is whole number,you would see:
So I have a workaround for you:
Create 2 columns as below:
Column = RIGHT('Table'[X],4)
rankx = 'Table'[Column]&RANKX(FILTER('Table','Table'[Column]=EARLIER('Table'[Column])),'Table'[X],,ASC,Dense)
Then you would see the 2 additional columns in your table such as below:
Change the column "rankx" to whole number and put it in X-axis,you will see:
You could also check the reference below :
https://www.tutorialgateway.org/scatter-chart-in-power-bi/
For my sample .pbix file,pls see attached.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |