Line chart with years stacked

[Craig3TCE]

Good morning all,

I'm trying to create the following -

This was created in Excel.

I have 2 columns from Direct query, date and balance.

I'm able to achieve the following -

I got to this by adding the Date Hierarchy from a date table into the axis, Year into the legend and balance into values and then drilling down to day level.

When I remove Year from the axis, I get the following -

Is there a way to achieve the original Excel line chart in Power BI?

Many thanks, Craig

[v-kelly-msft]

Hi  @Craig3TCE ,

Is your issue solved now?If not,could you pls check my last reply?

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Craig3TCE]

Hi Kelly, apologies it's not my dataset, it's from a colleague. I'm waiting for a stripped back version to come through without any confidential data.

We're using Direct Query - if I upload the PBIX, it will have to be an imprted dataset - will this affect the report? From my experience, dates can act very differently on an imported dataset vs. Direct Query.

[v-kelly-msft]

Hi  @Craig3TCE ,

Apologies for the late reply.

Yes,it would be different,I dont have the access your dq mode dataset,pls share me an imported one.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[v-kelly-msft]

Hi @Craig3TCE ,

Could you pls provide your .pbix file for test?Remember to remove the confidential information.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!