Data Granularity

[JRive116]

Hi everybody!
I'm a rookie in PBi and need some help.

I'm pulling 2 folders. Folder "A" has excel tables with minute increment flow measurement data for 12 months. Folder "B" has excel tables with hour increment flow measurement data for 12 months. I want to display both datasets in 1 line chart visual. I've tried creating many - one, many -many relationships using index tables to account for repeated values. When trying to use the visual, it shows what i think is the total count of datapoints that correspond to each "same" minute in a year.

Any help on this would be appreciated. 
Thank you!

[JRive116]

@Greg_Deckler 

I believe you did it!
I could not quite understand what @AmiraBedh said but I appreciate your input as well!

[JRive116]

Sample data

Table "A"
DATE_TIME "A"	Flow "A"
1/1/2025 0:00	0
1/1/2025 0:10	0
1/1/2025 0:20	0
1/1/2025 0:30	0
1/1/2025 0:40	0
1/1/2025 0:50	0
1/1/2025 1:00	0
1/1/2025 1:10	0
1/1/2025 1:20	0
1/1/2025 1:30	0
1/1/2025 1:40	0
1/1/2025 1:50	0
1/1/2025 2:00	0
1/1/2025 2:10	0
1/1/2025 2:20	0
1/1/2025 2:30	0
1/1/2025 2:40	0
1/1/2025 2:50	0
1/1/2025 3:00	0
1/1/2025 3:10	0
1/1/2025 3:20	0
1/1/2025 3:30	0
1/1/2025 3:40	0
1/1/2025 3:50	0
1/1/2025 4:00	0
1/1/2025 4:10	0
1/1/2025 4:20	0
1/1/2025 4:30	0
1/1/2025 4:40	0
1/1/2025 4:50	0
1/1/2025 5:00	0
1/1/2025 5:10	0
1/1/2025 5:20	0
1/1/2025 5:30	0
1/1/2025 5:40	0
1/1/2025 5:50	0
1/1/2025 6:00	14.99
1/1/2025 6:10	32.18
1/1/2025 6:20	49.91
1/1/2025 6:30	53.86
1/1/2025 6:40	53.86
1/1/2025 6:50	53.86
1/1/2025 7:00	53.86
1/1/2025 7:10	55.85
1/1/2025 7:20	55.29
1/1/2025 7:30	52.95
1/1/2025 7:40	57.93
1/1/2025 7:50	79.69
1/1/2025 8:00	128.81
1/1/2025 8:10	191.08
1/1/2025 8:20	264.46
1/1/2025 8:30	344.84
1/1/2025 8:40	422.25
1/1/2025 8:50	499.01
1/1/2025 9:00	594.32
1/1/2025 9:10	625.26
1/1/2025 9:20	665.81
1/1/2025 9:30	682.56
1/1/2025 9:40	690.41
1/1/2025 9:50	695.31
1/1/2025 10:00	696.82
1/1/2025 10:10	695.72
1/1/2025 10:20	692.96
1/1/2025 10:30	686.34
1/1/2025 10:40	682.08
1/1/2025 10:50	678
1/1/2025 11:00	672.94
1/1/2025 11:10	667.42
1/1/2025 11:20	661.9
1/1/2025 11:30	655.47
1/1/2025 11:40	652.21
1/1/2025 11:50	647.72
1/1/2025 12:00	644.06
1/1/2025 12:10	640.73
1/1/2025 12:20	638.86
1/1/2025 12:30	636.95
1/1/2025 12:40	636.33
1/1/2025 12:50	636.46
1/1/2025 13:00	638.19
1/1/2025 13:10	646.27
1/1/2025 13:20	649.84
1/1/2025 13:30	653.06
1/1/2025 13:40	657.07
1/1/2025 13:50	661.05
1/1/2025 14:00	665.73
1/1/2025 14:10	670.4
1/1/2025 14:20	675.19
1/1/2025 14:30	678.59
1/1/2025 14:40	681.25
1/1/2025 14:50	684.21
1/1/2025 15:00	682.63
1/1/2025 15:10	678.52
1/1/2025 15:20	667.93
1/1/2025 15:30	647.76
1/1/2025 15:40	621.33
1/1/2025 15:50	568.5
1/1/2025 16:00	488.87
1/1/2025 16:10	403.95
1/1/2025 16:20	319.42
1/1/2025 16:30	239.2
1/1/2025 16:40	164.38
1/1/2025 16:50	98.43
1/1/2025 17:00	48.25
1/1/2025 17:10	17.36
1/1/2025 17:20	3.78
1/1/2025 17:30	0.58
1/1/2025 17:40	0.18
1/1/2025 17:50	0.11
1/1/2025 18:00	0.1
1/1/2025 18:10	0.06
1/1/2025 18:20	0.03
1/1/2025 18:30	0
1/1/2025 18:40	0
1/1/2025 18:50	0
1/1/2025 19:00	0
1/1/2025 19:10	0
1/1/2025 19:20	0
1/1/2025 19:30	0
1/1/2025 19:40	0
1/1/2025 19:50	0
1/1/2025 20:00	0
1/1/2025 20:10	0
1/1/2025 20:20	0
1/1/2025 20:30	0
1/1/2025 20:40	0
1/1/2025 20:50	0
1/1/2025 21:00	0
1/1/2025 21:10	0
1/1/2025 21:20	0
1/1/2025 21:30	0
1/1/2025 21:40	0
1/1/2025 21:50	0
1/1/2025 22:00	0
1/1/2025 22:10	0
1/1/2025 22:20	0
1/1/2025 22:30	0
1/1/2025 22:40	0
1/1/2025 22:50	0
1/1/2025 23:00	0
1/1/2025 23:10	0
1/1/2025 23:20	0
1/1/2025 23:30	0
1/1/2025 23:40	0
1/1/2025 23:50	0

Table "B"
DATE "B"	TIME "B"	Flow "B"
1/1/2025	1:00	2131
1/1/2025	2:00	2023
1/1/2025	3:00	1933
1/1/2025	4:00	1864
1/1/2025	5:00	1829
1/1/2025	6:00	1811
1/1/2025	7:00	1879
1/1/2025	8:00	1875
1/1/2025	9:00	1996
1/1/2025	10:00	2132
1/1/2025	11:00	2275
1/1/2025	12:00	2440
1/1/2025	13:00	2559
1/1/2025	14:00	2700
1/1/2025	15:00	2815
1/1/2025	16:00	2986
1/1/2025	17:00	3089
1/1/2025	18:00	3139
1/1/2025	19:00	3086
1/1/2025	20:00	2918
1/1/2025	21:00	2843
1/1/2025	22:00	2644
1/1/2025	23:00	2402
1/2/2025	0:00	2177

Expected output (hopefully without the steps)
Dark Blue is "B"
Light Blue is "A"

I want to be able to plot, in one visual, in a contiuous manner both lines. Currently is Sums up all of the values per point. I dont really have a clear answer as to how to get from 2 to 3. :S 
@Greg_Deckler 

[Greg_Deckler · Accepted solution]

@JRive116 I split your TableA date/time into a date and time columns. I then created a third table of distinct time values at the 10 minute increment level by doing this:

Time Table = DISTINCT( 'TableA'[DATE_TIME "A".2] )

Relate this to both of your tables to the time columns in each.

Plot it like this:

[AmiraBedh]

Hello !

Thank you for posting on MS Fabric community.

Keep 2 separate tables and both should be pointing to a unique minute level time table so you need to build a time table at minute grain for your 12 months 

Time =
VAR Start = MINX(ALL(FactMinute), FactMinute[DateTime])
VAR End   = MAXX(ALL(FactMinute), FactMinute[DateTime])
RETURN
ADDCOLUMNS(
    CALENDAR(Start, End),
    "MinuteStamp",
     [Date]
)

and in both fact tables you need to have a key column that matches the time table minute stamp.

For the minute fact you can use the minute date time and for the hourly fact you can create HourStart = DATETIME(Date, Hour, 0, 0) so it matches the time table at the exact hour.

Your relationships should be :

• Time[DateTime] (unique) : one-to-many to MinuteFact[DateTime]

• Time[DateTime] (unique) : one-to-many to HourFact[HourStart]

Both relationships can be active.

Then create your measures.

[Greg_Deckler]

@JRive116 Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.