Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
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
User | Count |
---|---|
106 | |
89 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |