Forum Discussion

Twinkie124's avatar
Twinkie124
Frequent Visitor
7 years ago

Line Graph has dots?

I am using Power BI Desktop and am trying to create a line chart with varying interval durations. The interval durations are the way they are for a reason. 

However, the line chart is not connecting the dots as I want it to. I am guessing it is because they are different interval durations along the x axis. Is there a way to get around this without having to change my data source? Like I said, the interval durations are the way they are for a reason.

 

Here is a OneDrive link to the data source if you can use OneDrive.

https://onedrive.live.com/view.aspx?resid=C2D8F82CECEA928%21696&id=documents


Just upload that to a new .pbix file and create the graph using the following settings:

The graph produced is shown below:



As you can see, the graph above has a line graph with dots on it because of varying interval durations.

I would like to be able to have a line graph with lines using the data from the graph with varying interval durations. Like I asked, is there a way to do this without having to change my data source?

14 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    What structure is your data in as I cant replicate the issue

    • Twinkie124's avatar
      Twinkie124
      Frequent Visitor

      The data structure (type?) for each column is shown below:

       

      LOCALINTERVAL

      LOCALHOUR_INTEGER

      DAYSAHEAD

      INTERVALDURATION

      ID

      VALUE

      Date/Time

      Whole Number

      Text

      Whole Number

      Whole Number

      Whole Number

      • Anonymous's avatar
        Anonymous
        Not applicable

        I meant more about if you have a wide or narrow table for example.

         

        Is each value for a dateime its own row so that you have multiple rows for each datetime or are all items for one datetime on the same row with each value having its own column