Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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 temp...
Need Help
  • v-robertq-msft's avatar
    v-robertq-msft
    5 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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's avatar
v-robertq-msft
Community Support
5 years ago

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi v-robertq-msft 

    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. 

    • v-robertq-msft's avatar
      v-robertq-msft
      Community Support
      5 years ago

      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.