Forum Discussion
Report builder - 3 vars in a graph with different timestamp
- 1 year ago
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
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_D121 year ago
Super User
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.