Forum Discussion
Helper IIIMultiple measures on single chart with multiple dates on X axis
Community SupportHi arb1782 ，
Create 3 measures as below:
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])))
And you will see:
Check the .pbix file attached.
Best Regards,
Kelly
Helper IIIThanks 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
Hi @arb1782 ,
Can you show me your expected output?Which "week commencing " do you wanna use?
Best Regards,
KellyDid I answer your question? Mark my post as a solution!- arb1782
Hi v-kelly-msft
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.
The date that would be on the visual would be:
Number of recorded created Number of records reviewed Number of records closed 01/06/2020 5 06/07/2020 4 08/06/2020 4 15/06/2020 3 13/07/2020 3 20/07/2020 1 Unfortunately I can't manipulate the tables in PowerQuery because my week commencing fields are calculated fields.
arb