Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |