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: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
TejasShah
Helper I
Helper I

Add manual measure with already existing data for a Line graph chart

‎05-02-2024 04:09 AM

I have a data table where I am getting daily data of Date and serial No

 

DateSerial No.
29-01-2024ABC1
29-01-2024ABC2
29-01-2024ABC3
29-01-2024ABC4
29-01-2024ABC5
30-01-2024ABC6
30-01-2024ABC7
31-01-2024ABC8
31-01-2024ABC9
31-01-2024ABC10
31-01-2024ABC11
01-02-2024ABC12
01-02-2024ABC13
02-02-2024ABC14
02-02-2024ABC15
02-02-2024ABC16
02-02-2024ABC17
03-02-2024ABC18
03-02-2024ABC19
04-02-2024ABC20
05-02-2024ABC21
05-02-2024ABC22
05-02-2024ABC23
06-02-2024ABC24
06-02-2024ABC25
06-02-2024ABC26
06-02-2024ABC27
06-02-2024ABC28
07-02-2024ABC29
07-02-2024ABC30
08-02-2024ABC31
09-02-2024ABC32
10-02-2024ABC33
10-02-2024ABC34
10-02-2024ABC35
10-02-2024ABC36
11-02-2024ABC37
12-02-2024ABC38
12-02-2024ABC39
12-02-2024ABC40
13-02-2024ABC41
14-02-2024ABC42
15-02-2024ABC43
16-02-2024ABC44
16-02-2024ABC45
17-02-2024ABC46
17-02-2024ABC47
17-02-2024ABC48
17-02-2024ABC49
18-02-2024ABC50
19-02-2024ABC51
20-02-2024ABC52
21-02-2024ABC53
21-02-2024ABC54
21-02-2024ABC55
21-02-2024ABC56
21-02-2024ABC57
21-02-2024ABC58
22-02-2024ABC59
22-02-2024ABC60
22-02-2024ABC61
23-02-2024ABC62
24-02-2024ABC63
24-02-2024ABC64
24-02-2024ABC65
24-02-2024ABC66
24-02-2024ABC67
24-02-2024ABC68
24-02-2024ABC69
25-02-2024ABC70
25-02-2024ABC71
25-02-2024ABC72
25-02-2024ABC73
26-02-2024ABC74
27-02-2024ABC75
28-02-2024ABC76
28-02-2024ABC77
28-02-2024ABC78
28-02-2024ABC79
29-02-2024ABC80
01-03-2024ABC81
01-03-2024ABC82
01-03-2024ABC83
01-03-2024ABC84
01-03-2024ABC85
01-03-2024ABC86
01-03-2024ABC87
01-03-2024ABC88
01-03-2024ABC89
01-03-2024ABC90
01-03-2024ABC91
02-03-2024ABC92
02-03-2024ABC93
02-03-2024ABC94
02-03-2024ABC95
02-03-2024ABC96
02-03-2024ABC97
02-03-2024ABC98
03-03-2024ABC99
04-03-2024ABC100
04-03-2024ABC101
05-03-2024ABC102
05-03-2024ABC103
05-03-2024ABC104
05-03-2024ABC105
05-03-2024ABC106
05-03-2024ABC107
05-03-2024ABC108
05-03-2024ABC109
05-03-2024ABC110
06-03-2024ABC111
06-03-2024ABC112
06-03-2024ABC113
06-03-2024ABC114
06-03-2024ABC115
06-03-2024ABC116
06-03-2024ABC117
07-03-2024ABC118
07-03-2024ABC119
07-03-2024ABC120
08-03-2024ABC121
09-03-2024ABC122
10-03-2024ABC123
10-03-2024ABC124
10-03-2024ABC125
10-03-2024ABC126
10-03-2024ABC127
10-03-2024ABC128
10-03-2024ABC129
10-03-2024ABC130
10-03-2024ABC131
11-03-2024ABC132
11-03-2024ABC133
12-03-2024ABC134
13-03-2024ABC135
14-03-2024ABC136
14-03-2024ABC137
14-03-2024ABC138
14-03-2024ABC139
14-03-2024ABC140
15-03-2024ABC141
15-03-2024ABC142
16-03-2024ABC143
17-03-2024ABC144
17-03-2024ABC145
17-03-2024ABC146
18-03-2024ABC147
18-03-2024ABC148
19-03-2024ABC149
20-03-2024ABC150
20-03-2024ABC151
20-03-2024ABC152
20-03-2024ABC153
20-03-2024ABC154
20-03-2024ABC155
20-03-2024ABC156
20-03-2024ABC157
20-03-2024ABC158
20-03-2024ABC159
20-03-2024ABC160
21-03-2024ABC161
21-03-2024ABC162
21-03-2024ABC163
21-03-2024ABC164
22-03-2024ABC165
22-03-2024ABC166
22-03-2024ABC167
22-03-2024ABC168
22-03-2024ABC169
22-03-2024ABC170
22-03-2024ABC171
22-03-2024ABC172
22-03-2024ABC173
22-03-2024ABC174
22-03-2024ABC175
23-03-2024ABC176
23-03-2024ABC177
23-03-2024ABC178
23-03-2024ABC179
24-03-2024ABC180
24-03-2024ABC181
24-03-2024ABC182
24-03-2024ABC183
24-03-2024ABC184
24-03-2024ABC185
24-03-2024ABC186
25-03-2024ABC187
25-03-2024ABC188
25-03-2024ABC189
25-03-2024ABC190
25-03-2024ABC191
25-03-2024ABC192
26-03-2024ABC193
26-03-2024ABC194
26-03-2024ABC195
27-03-2024ABC196
28-03-2024ABC197
28-03-2024ABC198
28-03-2024ABC199
28-03-2024ABC200
28-03-2024ABC201
29-03-2024ABC202
29-03-2024ABC203
29-03-2024ABC204
30-03-2024ABC205
30-03-2024ABC206
30-03-2024ABC207
30-03-2024ABC208
30-03-2024ABC209
30-03-2024ABC210
30-03-2024ABC211
31-03-2024ABC212
31-03-2024ABC213
31-03-2024ABC214
31-03-2024ABC215
31-03-2024ABC216
31-03-2024ABC217
31-03-2024ABC218
31-03-2024ABC219
31-03-2024ABC220
31-03-2024ABC221

 

Now that when I plot this data of Month Vs Sum of Distinct Count of Serial No, I get proper plots for February, March, April but since my DB table was created in late January, I do not have data of January to plot.

 

I have the total for the month of January, how can I merge my January month total along with remaining month's plot of the year.

 

TejasShah_0-1714648080264.png

 

Here the yellow line showcases target line, while the blue one is the Sum of Distinct Count of Serial nos. for that particular month.

Labels:
Message 1 of 3
239 Views
0
1 ACCEPTED SOLUTION
DataNinja777
Super User
Super User

‎05-02-2024 05:26 AM

Hi @TejasShah ,

 

You can get your required output by adding the measure of total January prior to implementation of serial number database.  Even if you don't have the data with same granularity, you can add in a measure the January total transactions.  You can replace the yellow highlighted hard-coded number with your January total measure prior to implementation fo the serial number database. 

DataNinja777_2-1714652760555.png

 

I attach an example pbix file below:

 

View solution in original post

Distinctcount serial #.pbix
Message 2 of 3
208 Views
2 REPLIES 2
TejasShah
Helper I
Helper I

‎05-08-2024 12:02 AM

@DataNinja777 thank you so much for your support, I was really useful. I could get the output which was required. Thanks, once again!

Message 3 of 3
171 Views
0
DataNinja777
Super User
Super User

‎05-02-2024 05:26 AM

Hi @TejasShah ,

 

You can get your required output by adding the measure of total January prior to implementation of serial number database.  Even if you don't have the data with same granularity, you can add in a measure the January total transactions.  You can replace the yellow highlighted hard-coded number with your January total measure prior to implementation fo the serial number database. 

DataNinja777_2-1714652760555.png

 

I attach an example pbix file below:

 

Distinctcount serial #.pbix
Message 2 of 3
209 Views

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

View All