Reply
avatar user
Anonymous
Not applicable

Overlay data of different times on the same visualtization

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!

1 ACCEPTED SOLUTION
TeigeGao
Solution Sage
Solution Sage

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

View solution in original post

1 REPLY 1
TeigeGao
Solution Sage
Solution Sage

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

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)