Forum Discussion
Fit to width Line chart
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 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.