Scatter Chart

[Anth_NC_QN]

Hi everyone,

English is not my native language and I'm a newb in PBI, so please do write me if you need more details or clarification.

I'm making a comparison dashboard on cattle breeds. It's mainly based on the evolution of weight according to different classifications, etc.

I'm trying to reproduce this scatter chart that i've done in excel :

► Y-axis = weight

► X-axis = age (in days ) during the weighing

► The yellow dots represent all individuals of the first breed selected (Breed1). The line represents the average weight

► The orange ones represent the second breed selected (Breed2). The orange line represents the average weight

1/ The first problem I encounter is showing all individuals on the chart for Breed1 (for eg) :

For the Y-axis, it seems that I have to resume the values (sum, average, min, max, etc.) in order to display it. If i select "Don't resume", an error message about categories appears :

If i click on "See more details", the same error message pops up in a window.

Would you know how i can show every indivual of the selected breed please ?

2/ The second problem is how can I show the values of Breed1 and Breed2 in the same scatter chart (just like the scatter chart screenshot from excel) ?

...knowing that :

► I had to make a disconnected table for Breed2 in order to use separate slicers of the same category for Breed1 and Breed2 :

► I used the fx TREATAS in order to display the results of Breed2 in the bar chart :

MoyPiRace2 =

CALCULATE(

    AVERAGE('Pesées Pi'[Valeur]),

    TREATAS(VALUES('REF RACE 2'[Race]), IPG[Race]),

    TREATAS(VALUES('REF RACE 2'[Sexe (Pesées détail)]), IPG[Sexe (Pesées détail)]),

    TREATAS(VALUES('REF RACE 2'[Rang de velage]), IPG[Rang de velage]),

    TREATAS(VALUES('REF RACE 2'[Qualification]), IPG[Qualification])

    )

► Here's the data model :

Where the dim tables are IPG / REF RACE 2 / ELEVEURS. And the 2 fact tables are Pesées pi and Pesées détail.

Your help will be much appreciated.

Thank you

[AnthNC]

@amitchandak Hi, thanks for your answer.

So problem 1/ is sorted out. The values had to be in numerical format.

Now for problem 2/, I have been going through tutorials and forums but I can't find a way to insert a second series of data on the Y-axis, knowing that the slicers for the second series of data are from a disconnected table.

@amitchandak I don't know which measures i could use to do that. Could you help me out please ?

Here's the link to the pbix:

https://drive.google.com/file/d/18ZBf4j9bOwlvV0xcFELKYqyASk8UPqBz/view?usp=sharing

Many thanks

[AmandaJansen]

Thanks, my issue has been fixed.

[AnthNC]

PS : login name change because i'm not writing from my work microsoft account

[amitchandak]

@Anth_NC_QN , In Power bi scatter you have to use measure on both axis and details and legend to have dots