Can't get multiple lines in visual in Power BI

[Analitika]

Hi,

I have visual of sales and hours. I need make that will appear two lines if we select 2021,2022 years. Now when I select 2021,2022 I am getting one average line. But I need see that lines quantity as selected years. How to fix my visual or measures? I am attaching .pbix file to be more clear about my case. My pbix is placed here: https://drive.google.com/file/d/15hoVTSJQb41v_QrsBVnAbDcdY3pOI6SE/view?usp=sharing.

[TomMartens]

Hey @Analitika ,

unfortunately the link requires a login, make sure that the link allows anonymous access.

Not sure, but maybe adding the years column to te legend bucket of your line chart might help. Of course you have to be aware, that this will only work if only have one colum/measuer added to your values bucket.

Regards,

Tom

[Analitika]

Check again link.

[TomMartens]

HEy @Analitika ,

still the same:

For privacy reasons I will not request access.

Regards,

Tom

[Analitika]

What is your email I will send link.

[TomMartens]

Hey @Analitika ,

for other reasons I will only try to answer questions if sample data is publicly available meaning accessible by everyone. Due to this, I will not share my email.

Regards,
Tom

[Analitika]

Here is a link: https://files.fm/u/7bbf59hk3.