Forum Discussion
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
- AnonymousNot applicable
What structure is your data in as I cant replicate the issue
- Twinkie124Frequent 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
- AnonymousNot 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