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 connec...
What structure is your data in as I cant replicate the issue
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
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
My data table is structured as a wide table. The “Values” are all the same measurement/unit.
So for example, for “LocalInterval” 8/7/2018 12:00 AM, I have “Values”: 95 (1 row) and 247 (6 rows), one for each “Days Ahead” category for that interval.
