cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dthuler Frequent Visitor
Frequent Visitor

Mixing several time dimensions in a single chart

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

2018-10-15_09-21-01.pngXL example

3 REPLIES 3
v-danhe-msft Super Contributor
Super Contributor

Re: Mixing several time dimensions in a single chart

Hi @dthuler,

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

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
dthuler Frequent Visitor
Frequent Visitor

Re: Mixing several time dimensions in a single chart

 

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

 

2018-10-16_08-19-44.png

 

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

2018-10-16_08-25-03.png

 

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

2018-10-16_08-29-18.png 

 

Regards,

David

dthuler Frequent Visitor
Frequent Visitor

Re: Mixing several time dimensions in a single chart

up... anyone have an idea?

How can I better help you understand the report?

David

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 75 members 1,051 guests
Please welcome our newest community members: