Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
molegris
Advocate III
Advocate III

How to display data points for a given level of details

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 :

  • I work in education.  This chart display stats for a single course selected by the user.
  • X-axis display sessions (fall, winter and summer of every year)
  • Y-axis is the success rate (percentage of students who passed the cours)
  • Desired level of details : Students who registered for this course are devided into groups of about 25 students.
    So each dot on the chart should represent a single group.
  • Bubble size is linked to the number of students in that particular group.

 

Power BI does not allow me to put the GroupNumber on the Detail value.

Cannot use "Detail"Cannot use "Detail"

 

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.

Legend gives the right level of details but I don't need all the colorsLegend gives the right level of details but I don't need all the colors

 

Any idea how I can do it?  

 

Thanks

--mo

1 ACCEPTED SOLUTION
v-kelly-msft
Community Support
Community Support

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:

v-kelly-msft_0-1620291101239.png

If X-axis is whole number,you would see:

v-kelly-msft_1-1620291179249.png

 

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:

v-kelly-msft_2-1620291264359.png

 

 

Change the column "rankx" to whole number and put it in X-axis,you will see:

v-kelly-msft_3-1620291301350.png

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!

 

View solution in original post

1 REPLY 1
v-kelly-msft
Community Support
Community Support

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:

v-kelly-msft_0-1620291101239.png

If X-axis is whole number,you would see:

v-kelly-msft_1-1620291179249.png

 

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:

v-kelly-msft_2-1620291264359.png

 

 

Change the column "rankx" to whole number and put it in X-axis,you will see:

v-kelly-msft_3-1620291301350.png

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!

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.