Forum Discussion
Line chart shows multiple lines in Visual Pane when only one measure was selected.
Hi Jhorman_Gomez ,
The issue comes from how the latest versions of Power BI Desktop are handling the line chart "series" formatting when a date column is on the X-axis. Normally, if you only have one measure in Y-axis, you should see just one line in formatting. But in your case, it is displaying each distinct date value as a separate series. That’s why the format dropdown lists of “lines” named with dates it thinks each point is a separate line.
This started appearing after a recent update Rolling back doesn’t always fix it, because the behavior may be tied to your PBIX file metadata once saved in a newer version.Please try below workarounds to fix the issue.
1. Instead of dragging Date directly to X-axis, try below measure
MonthYear = FORMAT('Date'[Date], "YYYY-MM")
or use your Year-Month column in the Date table. This groups dates and ensures Power BI doesn’t try to treat each date as its own category.
2. Disable “Show all series”, In the formatting pane Lines --> Show for all series, make toggle it Off. That way Power BI won’t try to render formatting options per series.
3. Use a measure as Legend, Create a calculated column in your Date table:
SingleLegend = "Sales"
Then drop it into the Legend well. That forces Power BI to treat the chart as a single line series, which cleans up the format pane.
4. Even if you are not explicitly using hierarchy, Power BI sometimes forces one. Right-click your Date field in the Fields pane --> uncheck Date Hierarchy, and make sure you are using just the raw column.
5. This looks like a bug introduced in the August/September builds of Power BI Desktop. If possible, test with the June 2025 build.
Note: Best workaround is adding a dummy constant Legend "Sales" or using Year-Month instead of full Date. That way you regain control over the line formatting and can safely add multiple measures later.
I hope this information helps. Please do let us know if you have any further queries.
Regards,
Dinesh
Hi Jhorman_Gomez ,
It is a expected behaviour in Power BI. i have replicated from my side. I have choosed country field in X-axis. In Lines settings --> Categories field shows all the country values. If we place any field on X-axis, it will show all the values. It is a expected behaviour in Line chart. As you mentioned in your question , you had replicated in other PBIX file, it was worked perfectly. Please share expected output snap.
Regards,
Dinesh
Hello, v-dineshya , the issue is with time series not other dimensions. Whenever I put dates or YEAR + MONTH on the x-axis the lines format no longer allows me to modify the only measure in the visualization. It shows as many categories as values in the dates dimension, I no longer can edit something so basic as the color of the line because the visualization splits it into multiple categories.
Hi Jhorman_Gomez ,
The issue comes from how the latest versions of Power BI Desktop are handling the line chart "series" formatting when a date column is on the X-axis. Normally, if you only have one measure in Y-axis, you should see just one line in formatting. But in your case, it is displaying each distinct date value as a separate series. That’s why the format dropdown lists of “lines” named with dates it thinks each point is a separate line.
This started appearing after a recent update Rolling back doesn’t always fix it, because the behavior may be tied to your PBIX file metadata once saved in a newer version.Please try below workarounds to fix the issue.
1. Instead of dragging Date directly to X-axis, try below measure
MonthYear = FORMAT('Date'[Date], "YYYY-MM")
or use your Year-Month column in the Date table. This groups dates and ensures Power BI doesn’t try to treat each date as its own category.
2. Disable “Show all series”, In the formatting pane Lines --> Show for all series, make toggle it Off. That way Power BI won’t try to render formatting options per series.
3. Use a measure as Legend, Create a calculated column in your Date table:
SingleLegend = "Sales"
Then drop it into the Legend well. That forces Power BI to treat the chart as a single line series, which cleans up the format pane.
4. Even if you are not explicitly using hierarchy, Power BI sometimes forces one. Right-click your Date field in the Fields pane --> uncheck Date Hierarchy, and make sure you are using just the raw column.
5. This looks like a bug introduced in the August/September builds of Power BI Desktop. If possible, test with the June 2025 build.
Note: Best workaround is adding a dummy constant Legend "Sales" or using Year-Month instead of full Date. That way you regain control over the line formatting and can safely add multiple measures later.
I hope this information helps. Please do let us know if you have any further queries.
Regards,
Dinesh
Hi @Jhorman_Gomez ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.
Regards,
Dinesh