Forum Discussion
1 X axis from multiple sources
So, I am new to Power BI, I am trying to create a clustered column chart to track a process.
Tasks created and completed by week no.
Week no calc is done, but I need to plot the completion against Completion week not creation week.
What is happening is i have a dual X axis and the completion weeks are found in the clustered column of the created week of that event.
Am I missing something obvious?
I've currently got the chart in concatenated X axis mode this has not solved the problem.
2 Replies
- zenisekd
Super User
What you need to do is to create a separate calendar table, to which you will connect the table(s) via the create and finsih date. If it all comes from one table, one of the relations will be unactive and you will activate it with use relationship in the calculation.
If created and completed comes from two tables, you just simply both map it to the date table.
Next you put the weekn number into the X-axis and the calculations into the Y axes.
To do this, study a little about date tables and how they work https://www.youtube.com/watch?v=_n6iIqm_CKE
and about how to use userlationship() when working with multiple date columns in one table.Thanks, the Youtube video wasnt much help but i google'ed how to make a date table for a better method.
Worked perfectly.
