Report builder - 3 vars in a graph with different timestamp

[aplaza1]

Hi,

I have the data you see in Table, always 3 variables with different timestamp.

I just want to plot 3 vars on one grafic, but it seems no to interpolate or something,

How can I configure de graph? can you help me?

Thanks in advance

[Anonymous]

Hi,Poojara_D12 ,thanks for your concern about this issue.

Your answer is excellent!
And I would like to share some additional solutions below.

Hello,@aplaza1 .I am glad to help you.
I think the suggestion made by Poojara_D12  is helpful to you.
After my testing of your data. Thinking that there might be some problem with your data itself, which is causing the data in the paginated reports not to display as expected, while your actual operation is rihght. (field placement is fine)
Perhaps you want results like this?
The data in the timestamp field that is the x-axis is too spread out.

You can see that I've changed the appropriate data in your timestamp column. (The DATE Time)

If the X-axis is going to place timestamps, then you need to make sure that the difference between the timestamps under each category is not too great, and that the vast majority of the data in their DATE TIME columns should be the same from one group to the next.
By modifying the data in the DateTime column so that each group has several identical timestamps (DATE TIME), you can effectively solve the chart display problems caused by inconsistent timestamps. In this way, each variable in the chart is aligned at the same point in time, ensuring a better visualization of the data.
Of course such data modification will directly modify your data source. 

Here's a chart to visualize the problem :

You can see that the data in the DATE TIM column on the right has not been processed by group, and only one of the groups is being displayed correctly, while the other two are not. This indicates that your problem is due to inconsistent timestamps
If possible, you can try to use another chart to display the data (if you can't modify your original data)

If you can use Power BI Dektop to create reports, then you may be able to present the raw data better, Power BI Report Builder provides relatively few features compared to Power BI Desktop, and sometimes there may be some performance similar to issue (the confusion of the data leads to visual presentation errors).

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian

[Poojara_D12]

Hi @Anonymous 

Thank you for the kind words, Happy to help  🙂

If possible consider subscribing my Youtube channel for basic to advance power BI and SQL related content, link given below.

[Poojara_D12]

Hi @aplaza1 

The image you've shared appears to be a table or a screenshot from a data logging or visualization system. It shows data for three variables: "UTA1-TT01.PV," "UTA01-TT01.SP_ALM_HH," and "UTA01-TT01.SP_ALM_LL," each associated with different timestamps. The "VALUE" column indicates the measured or recorded values for each variable at the corresponding time. The "Gráficos" section at the top suggests that this data is intended to be visualized graphically. The challenge you're facing is that when you plot these variables, they don't create a smooth, continuous line graph as expected. Instead, they appear as a series of horizontal steps, indicating that the plotting tool is not correctly interpreting the timestamps as a continuous time axis for interpolation. This is likely because the timestamps are being treated as categorical labels rather than numerical values representing points in time. To fix this, the timestamps need to be converted into a numerical format that the plotting tool recognizes (like seconds since a specific point in time or a decimal representation of the date and time). Once the timestamps are in the correct numerical format, the plotting tool can then be configured to treat the time axis as continuous, allowing it to draw lines that connect the data points smoothly and accurately represent the changes in the variables over time.

[aplaza1 · Accepted solution]

Hi all,

The tittle 'VARIABLE' on the timestamp column you reffer to was just a string, it was my mistake because I added a new column an did not change the string text.

You were right about the Date, it was not in the correct order, so I saw that by default, this selection is empty, Dont know why:

Just selecting here the TIMESTAMP, I could plot th 3 variables:

In addition if I configure it as my client wants, I can obtain something beauty for a Temperature/Humidity or whatever in a room:

Thanks a lot