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 connec...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

Twinkie124's avatar
Twinkie124
Frequent Visitor
7 years ago

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
    7 years ago

    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

     

    • Twinkie124's avatar
      Twinkie124
      Frequent Visitor
      7 years ago

      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.

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Microsoft Employee
        7 years ago

        Hi Twinkie124,

         

        Can you share the pbix file? Which visual is it? Seems there isn't a line existed.

         

        Best Regards,

        Dale