Mixing several time dimensions in a single chart

[dthuler]

Hi Guys!

Making my way in my Power BI journey, I ended up last week with an interesting question I cannot find an elegant solution yet;

How can I mix different time dimensions in one chart like in the one below? 

Today, the only way for me is to draw 4 charts (last year, monthly, year-to-date and target), try to align them the best (which is not trivial here) and fix y-axis min and max to try to not mix everything up.

I am convince there must be a better way to solve this problem,

can you give me some hints how to achieve a neat result?

Best Regards,

David

XL example

[dthuler]

up... anyone have an idea?

How can I better help you understand the report?

David

[v-danhe-msft]

Hi @dthuler,

Could you please post me some sample data to have a test and post your desired result if possible?

Regards,

Daniel He

[dthuler]

Here is (an exerpt of) the structure I use in this report:

Now a sample of the data I use from Actuals table:

And finally (a simulation of) the result I would like to achieve ideally:

 

Regards,

David