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.
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.