Forum Discussion
Fit to width Line chart
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.
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.
5 Replies
- v-robertq-msft
Community Support
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.
- v-robertq-msft
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.