Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi there, I have a 3 room temperature datas and 1 outdoor temperature data, each recorded for every minute for 7 days. Totally 10080 rows of data. I have created a line chart to compare the room temperatures with outdoor temperature. As this has huge data, i need to scroll to see the rest of the graph. Is there a way to fit all these data into a single page to compare the temperatures without scrolling?
Thanks in advance.
Solved! Go to Solution.
Hi, @Anonymous
According to your sample picture, it seems like the time period between the Start and End you set is over 7 days.
You can try to go to the X-axis setting to set the Start as “2021-01-02” and the End as “2021-01-08”.
To avoid the aggregation value in your line chart, you can try to set the Date column in your line chart like this:
If you still have a problem, you can post your sample pbix file (without sensitive data) so that we can help you in advance.
How to Get Your Question Answered Quickly
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Anonymous
According to your description, you said you have 10080 rows of data and you want to make them displayed on one single page, I think paginated reports in Power BI can perfectly meet your requirement, you can follow these documents:
https://docs.microsoft.com/en-us/power-bi/paginated-reports/paginated-reports-faq
If you still have a problem, you can reply to me.
How to Get Your Question Answered Quickly
Thank you very much!
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-robertq-msft ,
Thanks for your reply. I don't want paginated reports as tables. I need a line chart with date and time in X axis and temperature readings in Y axis. Here is the data. The temperature is recorded for every minute for 7 days.
I have created time tables and date tables to create a link. I need a chart like this.
When I try to make line chart, I'm getting data for every minute of all 7 days. Instead, I need it for 24 hours of each day.
Is it possible to create a line chart showing all 7 day values with date and time?
How can I solve this?
Thanks in advance.
Hi, @Anonymous
According to your description and sample picture, I can understand your requirement clearly. I think you can go to the “Format” setting of this line chart->X-Axis->set the Start and End date of this chart to go across all the 7 days, like this:
And you can get what you want.
More info about line chart in Power BI
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks. I've tried this. I ended up with the below graph which is giving me the aggregated values.
But, all I need is the exact temperature values. If I drill down to next level in the hierachy, I am getting the graph with date, time and exact values without aggregation which is what I need.
But, since I have data recorded for every 1 minute for 7 days, I am getting only 1 hour of data in the report view of the chart and I need to scroll to see the rest. Is there a way to see all the datas in a single page without scrolling to check for maximum and minimum values for all 7 days?
Thanks in advance.
Hi, @Anonymous
According to your sample picture, it seems like the time period between the Start and End you set is over 7 days.
You can try to go to the X-axis setting to set the Start as “2021-01-02” and the End as “2021-01-08”.
To avoid the aggregation value in your line chart, you can try to set the Date column in your line chart like this:
If you still have a problem, you can post your sample pbix file (without sensitive data) so that we can help you in advance.
How to Get Your Question Answered Quickly
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
142 | |
76 | |
63 | |
51 | |
47 |
User | Count |
---|---|
214 | |
84 | |
61 | |
61 | |
60 |