clustered Chart Showing Incorrect Colors

[MkPowerBi]

Dear Gents,

I am creating a new Chart comparing sales between 2 years.

when i select the year 2018-2019 the 2018 sales appears in the correct colors on the chart same for 2019, but when i select 2019-2020, the year 2020 appears on the last year and 2019 remains Year to date, see below screenshot: the 2020 appears in Sales LY and 2019 appears in SalesYTD,can you please advise why ?

for YTD sales i am using this dax function : totalytd('total sales',date)

for LY sales i am using this dax function : Calculate('total sales',paralleperiod(date,-1,year)

The Numbers are correct but the colors should be the opposite

Appreciate Your help.

[Icey]

Hi @MkPowerBi ,

I can't reproduce your issue. Please share me a dummy PBIX file, removing real data and sensitive information. Then I'll conduct specific tests.

Best Regards,

Icey

[amitchandak]

Just shuffle the measures up and down and check. Also, check the color assigned to each measure and change and a revert one of them

[MkPowerBi]

Shuffling the measures wont work, the problem also in the legend names, 2020 should appear as YTD and 2019 as Last year

[MkPowerBi]

Shuffling the measures wont work, the problem also in the legend names, 2020 should appear as YTD and 2019 as Last year @amitchandak