Forum Discussion
Need help with plotting a line chart
I have the following data in a table:
Title ReportingDate Total
ABC 12/5/2025 100
ABC 12/12/2025 120
DEF 12/5/2025 10
DEF 12/5/2025 10
I need to plot it so it shows the Title and the dates and the increase/decrease/no change on a chart, just not sure where to put these fields ?
Hii EaglesTony
Use a Line chart and place ReportingDate on the X-axis, Total on the Y-axis, and Title in the Legend. This will create one line per Title (ABC, DEF) and show how the values increase or decrease across the reporting dates. No extra measures are needed the default line chart handles this setup correctly.
example below :
To build your line chart in Power BI, start by inserting a Line Chart visual and assigning ReportingDate to the X-axis. This ensures the dates appear in order across the chart. Make sure the ReportingDate column is set to a proper Date data type so the visual behaves correctly.
Next, place the Title field in the Legend area. This will create a separate line for each title—such as ABC and DEF—so you can easily compare their trends. Then add the Total field to the Values section, which will plot the numerical changes over time and show whether each title is increasing, decreasing, or staying the same.
Be aware that DEF appears twice on the same date in your data. Power BI will sum these values by default, resulting in 20 instead of 10. To avoid this, you can remove duplicates in Power Query or change the aggregation for Total from Sum to Average. Once these steps are set, your line chart will clearly display the pattern of changes for each title.
5 Replies
Hii EaglesTony
Use a Line chart and place ReportingDate on the X-axis, Total on the Y-axis, and Title in the Legend. This will create one line per Title (ABC, DEF) and show how the values increase or decrease across the reporting dates. No extra measures are needed the default line chart handles this setup correctly.
example below :
Hi EaglesTony
To assist you correctly, we first need to understand between which two values or dates you want to show the change.
Once that’s clear, we can tell you exactly how to place the fields in the line chart and how to calculate the increase/decrease.If you can share a small example of the expected result, that will help clarify it quickly.
To build your line chart in Power BI, start by inserting a Line Chart visual and assigning ReportingDate to the X-axis. This ensures the dates appear in order across the chart. Make sure the ReportingDate column is set to a proper Date data type so the visual behaves correctly.
Next, place the Title field in the Legend area. This will create a separate line for each title—such as ABC and DEF—so you can easily compare their trends. Then add the Total field to the Values section, which will plot the numerical changes over time and show whether each title is increasing, decreasing, or staying the same.
Be aware that DEF appears twice on the same date in your data. Power BI will sum these values by default, resulting in 20 instead of 10. To avoid this, you can remove duplicates in Power Query or change the aggregation for Total from Sum to Average. Once these steps are set, your line chart will clearly display the pattern of changes for each title.
Hi EaglesTony ,
We would like to confirm if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.
rohit1991, Ritaf1983 & 123abc, Thanks for your prompt response
Thank you for your patience and look forward to hearing from you.
Best Regards,
Prashanth Are
MS Fabric community supportHi @EaglesTony ,
We would like to confirm if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.
Thank you for your patience and look forward to hearing from you.
Best Regards,
Prashanth Are
MS Fabric community support
