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

      • Twinkie124's avatar
        Twinkie124
        Frequent Visitor
        7 years ago

        I wasn't sure how to share the pbix file on here...Sorry  I am new to Power BI and this forum. I shared the data source with Onedrive in my first post, and you can download that and setup the pbix file yourself the way I showed? I was using the area chart. If there is an easy way to share the pbix file, I will gladly do that!