Overlay data of different times on the same visualtization

[Anonymous]

Admittedly, I am very new to PowerBI, that being said...

I have 3 different csv files that I am trying to overlay on a line chart visualization, they are:

% CPU Used - taken every 5 mins on the fives

% Memory Used - taken every 5 mins on the fives

% Disk filled - taken daily around 10pm.

I created a relationship in the model tab of the date/time field, however the % Disk filled ONLY shows on the line chart when one of the day/time values happens to match with one of the ones from memory/cpu.

Why wouldn't  % Disk filled just show in between one of the date values going across the x axis on the bottom?  How do I make it show up?

Thanks!

[TeigeGao · Accepted solution]

Hi @Anonymous ,

In your scenario, the % Disk filled use the different date/time field, as a result, it will not display the value of % Disk filled, as a workaround, you can try to use the hour as the x-axis, calculate the sum of every item in each hour, then display them in the same visual.

Best Regards,

Teige