Month of February is only displaying once in line chart and should display 2x

[brightbright]

Hi

I've created a table in Excel that starts in February 2024 and ends in February 2025. From there, I'm using the table in Excel to visualize a line chart that's sorted by the target column and is sorted ascending.

I noticed that February is only displayed one time at the end of the chart and has summed the targets from February 2024 to February 2025.

You'll also notice in Power BI under the filtering section, that there's a #2 by February.

Regarding the table in Excel the date is displayed as Feb-24 but in the fx box the date is displayed 2024.

What do I need to do format the date correctly so February 2024 is at the start of the chart and February 2025 is at the end?

Screenshots below:

FilterLine chartDate

[Greg_Deckler · Accepted solution]

@brightbright So, you will need to create a column that distinguishes February 2024 from February 2025, such as FORMAT([Date], "mmm-yy"). You would then use that in your axis. You will also need a Sort By column such as YEAR([Date]) * 100 + MONTH([Date]).

[brightbright]

Thanks, @Greg_Deckler, I'll give this a try.