Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Pete230
Helper II
Helper II

Scattering of Y values on the X axis, which have the same X value for each month.

‎09-13-2022 05:56 AM

Hi together,

 

I'm struggeling since a while with a simple graph in Power BI; I would like to scatter around 5.000 values over the year, the X-Axis value is the month, so I do have each month around 420 values, which I'd like to scatter so there not in one line and better clickable.

In Excel I do with the scatter graph (Screenshoot 1). In power BI I'm not capable of.
Does anyone of you had the same issue, or any experience solving that?

That would be great. 🙂

 

 

PeteScreenshot 1 - Excel Example ( How it should look like in power bi)Screenshot 1 - Excel Example ( How it should look like in power bi)Screenshot 2, unscattered values (how it should not look like)Screenshot 2, unscattered values (how it should not look like)

Labels:
Message 1 of 12
552 Views
0
1 ACCEPTED SOLUTION
lbendlin
Super User
Super User
In response to Pete230

‎09-20-2022 11:57 AM

something like the attached?

 

View solution in original post

random scatter.pbix
Message 6 of 12
461 Views
11 REPLIES 11
Pete230
Helper II
Helper II

‎10-22-2022 04:56 AM

Hi @lbendlin,

thanks for your solution, it works great. Now I would like to Add a column "scattered month" to my Date table in order to do all my calculations on the same basis. Unfornatly the new column I made does not give the scattered random numbers, do you perhaps know why?

Pete230_0-1666439753375.png

Best regards

Pete

Message 9 of 12
407 Views
0
lbendlin
Super User
Super User
In response to Pete230

‎10-22-2022 01:29 PM

You need to do that in Power Query, not in DAX.

Message 10 of 12
391 Views
0
Pete230
Helper II
Helper II
In response to lbendlin

‎10-24-2022 02:35 AM

Hi @lbendlin,

ok I recreated a date table in PQ now, and added a scatter month column, the table has a date and a scatter month column:

Pete230_0-1666603584762.png

in my data model the date columns of other tables are connected with this date table of PQ now.
When I build a visual now with the scatter column on the X-achsis it works perfectly, like in the Screenshot:

Pete230_1-1666603818489.png

until I add the data i would like to show in the Y-achsis, now evertyhing is line again:

Pete230_2-1666603953641.png

but still on random numbers, so the 12 is 12,4 for instance, but everything is on line.

The data im showin is a messure which takes data from the tables which are connected to the date table I mentioned above.


Do you have any advice why this is happening and the visual data is not scattered?

Best regards and thanks for your help.


Pete

Message 11 of 12
353 Views
0
lbendlin
Super User
Super User
In response to Pete230

‎10-24-2022 06:08 AM

Keine Ahnung.  Please provide the sample data.

Message 12 of 12
343 Views
0
lbendlin
Super User
Super User

‎09-14-2022 04:30 PM

Usually you do that by adding a random value (let's say from -10 to +10) to the X value.

 

NOTE:  Power BI will NOT let you render 5000 data points. It will force group your values.

 

If you want more help please provide sanitized sample data that fully covers your issue.

Message 2 of 12
492 Views
0
Pete230
Helper II
Helper II
In response to lbendlin

‎09-20-2022 05:47 AM

Hi Ibendlin;

 

thanks for your answer!
So when I alter the X Values for the date, I always have to do that by hand right? my data is always growing and Im looking a way to do it automaticaly like in the excel example.

 

At the moment Im at arround 250 to 300 values a month, so 5000 a year still fits me. in one year I gotta figure out a solution to that.


Do you know whether there is a good way not to alter the x achsis data by hand?

 

Thank you and regards

 

Pete

Message 3 of 12
483 Views
0
lbendlin
Super User
Super User
In response to Pete230

‎09-20-2022 05:52 AM

If you want more help please provide sanitized sample data that fully covers your issue.

Message 4 of 12
477 Views
0
Pete230
Helper II
Helper II
In response to lbendlin

‎09-20-2022 08:54 AM

Hi Ibendin,

Im not sure how to insert a table properly, so I post it here, the outcome is like that, unscattered:

Pete230_0-1663689092657.png

 

NameValueMonth
B               15,401.01.2022
C               15,801.01.2022
D               13,001.01.2022
E               13,001.01.2022
F               12,401.01.2022
G               11,301.01.2022
H                  9,101.01.2022
I               12,001.01.2022
J               12,001.01.2022
K               16,001.01.2022
L               10,601.01.2022
M               10,601.01.2022
N               12,301.01.2022
O               12,301.01.2022
P               13,001.01.2022
Q               13,001.01.2022
R               13,001.01.2022
S               13,001.01.2022
T               13,001.01.2022
U               13,001.01.2022
V               13,001.01.2022
W               13,001.01.2022
X               13,201.01.2022
Y               13,201.01.2022
Z               13,201.01.2022
B               40,401.02.2022
C               52,601.02.2022
D               50,601.02.2022
E               50,601.02.2022
F               28,301.02.2022
G               31,301.02.2022
H               30,801.02.2022
I               22,201.02.2022
J               22,201.02.2022
K               34,301.02.2022
L               32,801.02.2022
M               32,801.02.2022
N               30,401.02.2022
O               30,401.02.2022
P               47,301.02.2022
Q               47,301.02.2022
R               47,301.02.2022
S               47,301.02.2022
T               47,301.02.2022
U               47,301.02.2022
V               47,301.02.2022
W               47,301.02.2022
X               44,801.02.2022
Y               44,801.02.2022
Z               44,801.02.2022
B             104,401.03.2022
C             130,001.03.2022
D             127,301.03.2022
E             127,301.03.2022
F               88,601.03.2022
G               86,001.03.2022
H               87,601.03.2022
I               92,001.03.2022
J               92,001.03.2022
K               91,301.03.2022
L               94,801.03.2022
M               94,801.03.2022
N               87,501.03.2022
O               87,501.03.2022
P             117,801.03.2022
Q             117,801.03.2022
R             117,801.03.2022
S             117,801.03.2022
T             117,801.03.2022
U             117,801.03.2022
V             117,801.03.2022
W             117,801.03.2022
X             117,701.03.2022
Y             117,701.03.2022
Z             117,701.03.2022
B             116,301.04.2022
C             119,801.04.2022
D             118,201.04.2022
E             118,201.04.2022
F             124,201.04.2022
G               88,501.04.2022
H               91,801.04.2022
I             101,201.04.2022
J             101,201.04.2022
K               88,801.04.2022
L             108,201.04.2022
M             108,201.04.2022
N               85,701.04.2022
O               85,701.04.2022
P             109,301.04.2022
Q             109,301.04.2022
R             109,301.04.2022
S             109,301.04.2022
T             109,301.04.2022
U             109,301.04.2022
V             109,301.04.2022
W             109,301.04.2022
X             107,501.04.2022
Y             107,501.04.2022
Z             107,501.04.2022
B             154,801.05.2022
C             166,401.05.2022
D             164,001.05.2022
E             164,001.05.2022
F             138,701.05.2022
G             147,601.05.2022
H             144,601.05.2022
I             139,201.05.2022
J             139,201.05.2022
K             142,701.05.2022
L             155,701.05.2022
M             155,701.05.2022
N             141,301.05.2022
O             141,301.05.2022
P             136,301.05.2022
Q             136,301.05.2022
R             136,301.05.2022
S             136,301.05.2022
T             136,301.05.2022
U             136,301.05.2022
V             136,301.05.2022
W             136,301.05.2022
X             135,201.05.2022
Y             135,201.05.2022
Z             135,201.05.2022
B             162,201.06.2022
C             156,401.06.2022
D             151,801.06.2022
E             151,801.06.2022
F             153,001.06.2022
G             155,001.06.2022
H             138,601.06.2022
I             153,601.06.2022
J             153,601.06.2022
K             156,101.06.2022
L             163,501.06.2022
M             163,501.06.2022
N             158,901.06.2022
O             158,901.06.2022
P             145,801.06.2022
Q             145,801.06.2022
R             145,801.06.2022
S             145,801.06.2022
T             145,801.06.2022
U             145,801.06.2022
V             145,801.06.2022
W             145,801.06.2022
X             124,701.06.2022
Y             124,701.06.2022
Z             124,701.06.2022
B             142,501.07.2022
C             145,301.07.2022
D             143,001.07.2022
E             143,001.07.2022
F             148,401.07.2022
G             138,701.07.2022
H             129,801.07.2022
I             145,401.07.2022
J             145,401.07.2022
K             104,701.07.2022
L             145,501.07.2022
M             145,501.07.2022
N             115,201.07.2022
O             115,201.07.2022
P             149,201.07.2022
Q             149,201.07.2022
R             149,201.07.2022
S             149,201.07.2022
T             149,201.07.2022
U             149,201.07.2022
V             149,201.07.2022
W             149,201.07.2022
X             148,201.07.2022
Y             148,201.07.2022
Z             148,201.07.2022
B             130,001.08.2022
C             139,701.08.2022
D             134,801.08.2022
E             134,801.08.2022
F             123,101.08.2022
G             128,701.08.2022
H             122,801.08.2022
I             124,301.08.2022
J             124,301.08.2022
K             112,601.08.2022
L             140,601.08.2022
M             140,601.08.2022
N             120,601.08.2022
O             120,601.08.2022
P             137,101.08.2022
Q             137,101.08.2022
R             137,101.08.2022
S             137,101.08.2022
T             137,101.08.2022
U             137,101.08.2022
V             137,101.08.2022
W             137,101.08.2022
X             131,201.08.2022
Y             131,201.08.2022
Z             131,201.08.2022
B001.09.2022
C001.09.2022
D001.09.2022
E001.09.2022
F001.09.2022
G001.09.2022
H001.09.2022
I001.09.2022
J001.09.2022
K001.09.2022
L001.09.2022
M001.09.2022
N001.09.2022
O001.09.2022
P001.09.2022
Q001.09.2022
R001.09.2022
S001.09.2022
T001.09.2022
U001.09.2022
V001.09.2022
W001.09.2022
X001.09.2022
Y001.09.2022
Z001.09.2022
B001.10.2022
C001.10.2022
D001.10.2022
E001.10.2022
F001.10.2022
G001.10.2022
H001.10.2022
I001.10.2022
J001.10.2022
K001.10.2022
L001.10.2022
M001.10.2022
N001.10.2022
O001.10.2022
P001.10.2022
Q001.10.2022
R001.10.2022
S001.10.2022
T001.10.2022
U001.10.2022
V001.10.2022
W001.10.2022
X001.10.2022
Y001.10.2022
Z001.10.2022
B001.11.2022
C001.11.2022
D001.11.2022
E001.11.2022
F001.11.2022
G001.11.2022
H001.11.2022
I001.11.2022
J001.11.2022
K001.11.2022
L001.11.2022
M001.11.2022
N001.11.2022
O001.11.2022
P001.11.2022
Q001.11.2022
R001.11.2022
S001.11.2022
T001.11.2022
U001.11.2022
V001.11.2022
W001.11.2022
X001.11.2022
Y001.11.2022
Z001.11.2022
B001.12.2022
C001.12.2022
D001.12.2022
E001.12.2022
F001.12.2022
G001.12.2022
H001.12.2022
I001.12.2022
J001.12.2022
K001.12.2022
L001.12.2022
M001.12.2022
N001.12.2022
O001.12.2022
P001.12.2022
Q001.12.2022
R001.12.2022
S001.12.2022
T001.12.2022
U001.12.2022
V001.12.2022
W001.12.2022
X001.12.2022
Y001.12.2022
Z001.12.2022

 

Thanks for your time and regards

 

 

Message 5 of 12
471 Views
0
lbendlin
Super User
Super User
In response to Pete230

‎09-20-2022 11:57 AM

something like the attached?

 

random scatter.pbix
Message 6 of 12
462 Views
Pete230
Helper II
Helper II
In response to lbendlin

‎09-21-2022 02:38 AM

Thats perfect! Ok you do it in power querry date +-0,4; the last bit Im looking for now is to see every moth on the x-achsis and not every 2nd, idealy in a written form.

In Excel I can choose the frequency here in power bi I cant find a option for that.

Pete230_0-1663753104376.png

 

Message 7 of 12
450 Views
0
lbendlin
Super User
Super User
In response to Pete230

‎09-21-2022 04:23 AM

I don't think you can do that with the standard scatter plot visual. You would need a custom visual for that.

Message 8 of 12
444 Views
0

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

View All