Multiple measures on single chart with multiple dates on X axis

Question

Hi&nbsp;I've got multiple measures I want to put on one time series graph. On the page I want to set this chart up, I also have a date slicer set up with months as big buttons. The months are sourced from a date table which links to the columns entitled 'xxxx month'&nbsp; (see below) and the measures have the relevant relationship specified with USERELATIONSHIP.&nbsp;Measure 1 = Number of records created, plotted by record creation date (week commencing), using default relationship Month (date table) to Record creation monthMeasure 2 = Number of record reviews, plotted by record review date (week commencing),&nbsp;using relationship Month (date table) to Record reviewed monthMeasure 3 = Number of closed records, plotted by record closed date (week commencing),&nbsp;using default relationship Month (date table) to Record closed month&nbsp;How might I go about putting these all on 1 graph but using the separate week commencing fields on the x axis?&nbsp;Dummy data here:&nbsp;IndexRecord creation dateRecord creation week commencingRecord creation monthRecord reviewed dateRecord reviewed week commencingRecord reviewed monthRecord closed dateRecord closed week commencingRecord closed month101/06/202001/06/2020June08/06/202008/06/2020June15/06/202015/06/2020June202/06/202001/06/2020June09/06/202008/06/2020June16/06/202015/06/2020June303/06/202001/06/2020June10/06/202008/06/2020June17/06/202015/06/2020June404/06/202001/06/2020June11/06/202008/06/2020June&nbsp;&nbsp;&nbsp;505/06/202001/06/2020June&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;609/07/202006/07/2020July13/07/202013/07/2020July20/07/202020/07/2020July710/07/202006/07/2020July&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;811/07/202006/07/2020July15/07/202013/07/2020July&nbsp;&nbsp;&nbsp;912/07/202006/07/2020July16/07/202013/07/2020July&nbsp;&nbsp;&nbsp;&nbsp;Thanksarb

amitchandak · Answer

arb1782 , refer if this blog can help
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
&nbsp;
For week in calendar you can refer :
https://community.powerbi.com/t5/Community-Blog/Any-Weekday-Week-Decoding-Date-and-Calendar-2-5-Power-BI-Turning/ba-p/1187482

v-kelly-msft · Answer

Hi arb1782 ，
&nbsp;
Create 3 measures as below:
&nbsp;
Measure 1 = CALCULATE(COUNT('Table'[Record creation week commencing]),FILTER(ALL('Table'),'Table'[Record creation month]=SELECTEDVALUE('Table 2'[Month])))Measure 2 = CALCULATE(COUNT('Table'[Record reviewed week commencing]),FILTER(ALL('Table'),'Table'[Record reviewed month]=SELECTEDVALUE('Table 2'[Month])))Measure 3 = CALCULATE(COUNT('Table'[Record closed week commencing]),FILTER(ALL('Table'),'Table'[Record closed month]=SELECTEDVALUE('Table 2'[Month])))
&nbsp;
And you will see:

Check the .pbix file attached.
&nbsp;Best Regards,Kelly
Did I answer your question? Mark my post as a solution!
&nbsp;

arb1782 · Answer

Thanks for the advice so far. I need to get the x axis to be 'week commencing' and for the measures to plot on that axis using data from three different 'week commencing' fields. I've played with your PBI file Kelly but it doesn't seem to solve my problem.

arb

v-kelly-msft · Answer

Hi &nbsp;@arb1782 ,
&nbsp;
Can you show me your expected output?Which "week commencing " do you wanna use?
&nbsp;
Best Regards,Kelly
Did I answer your question? Mark my post as a solution!

arb1782 · Answer

Hi v-kelly-msft&nbsp;I'm looking for all 3 'week commencing' fields to be plotted on the same axis. If I do this, the measures only plot against one of the fields, meaning that 1 measure is accurate and the 2 others are inaccurate.&nbsp;The date that would be on the visual would be:&nbsp;&nbsp;Number of recorded createdNumber of records reviewedNumber of records closed01/06/20205&nbsp;&nbsp;06/07/20204&nbsp;&nbsp;08/06/2020&nbsp;4&nbsp;15/06/2020&nbsp;&nbsp;313/07/2020&nbsp;3&nbsp;20/07/2020&nbsp;&nbsp;1&nbsp;Unfortunately I can't manipulate the tables in PowerQuery because my week commencing fields are calculated fields.&nbsp;arb

Forum Discussion

Multiple measures on single chart with multiple dates on X axis

5 Replies

Related content

MULTIPLE CARD

Multiple measures in matrix by year

Multiple dataViewMappings

How to show multiple metrics/measures in a visual?

Measure 'Contains' multiple.

Index	Record creation date	Record creation week commencing	Record creation month	Record reviewed date	Record reviewed week commencing	Record reviewed month	Record closed date	Record closed week commencing	Record closed month
1	01/06/2020	01/06/2020	June	08/06/2020	08/06/2020	June	15/06/2020	15/06/2020	June
2	02/06/2020	01/06/2020	June	09/06/2020	08/06/2020	June	16/06/2020	15/06/2020	June
3	03/06/2020	01/06/2020	June	10/06/2020	08/06/2020	June	17/06/2020	15/06/2020	June
4	04/06/2020	01/06/2020	June	11/06/2020	08/06/2020	June
5	05/06/2020	01/06/2020	June
6	09/07/2020	06/07/2020	July	13/07/2020	13/07/2020	July	20/07/2020	20/07/2020	July
7	10/07/2020	06/07/2020	July
8	11/07/2020	06/07/2020	July	15/07/2020	13/07/2020	July
9	12/07/2020	06/07/2020	July	16/07/2020	13/07/2020	July