Forum Discussion

ablackburn21's avatar
ablackburn21
New Member
8 years ago

Creating my first Chart

I am a new user.

 

I have a small dataset in excel that I imported to Power BI

 

 

 

The data is in Power BI adn I can see the field. When I select 2 fields, such as "Pending Date" and 'Sale $/SF", I get a line chart that doesnt seem to relate to the data.

 

 

I just want a simple Chart with the date on the Horizontal axis and the Sale $ / SF on the vertical Axis.

 

Help is appreciated.

 

 

1 Reply

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    Hi ablackburn21,

     

    When I select 2 fields, such as "Pending Date" and 'Sale $/SF", I get a line chart that doesnt seem to relate to the data.

    What do you say the line chart is not related to the dataset data? Could you explain with an example?

     

     

     

    I just want a simple Chart with the date on the Horizontal axis and the Sale $ / SF on the vertical Axis. 

    From above line chart, everything looks correct. Date is shown as X-axis and Sale $ / SF on the vertical Axis. If you want to display Date rather than Month on X-axis, please change "Date hierarchy" to "Date".

     

    Besides, any numeric fields added to Y-axis will be aggregated (sum, max, average, etc). That may be why the data values shown in chart looks different from source table.

     

    Regards,

    Yuliana Gu