Forum Discussion
arb1782
Helper III
Helper IIIMultiple measures on single chart with multiple dates on X axis
Hi 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 ...
v-kelly-msft
Community Support
Community SupportHi @arb1782 ,
Can you show me your expected output?Which "week commencing " do you wanna use?
Best Regards,
Kelly
Kelly
Did I answer your question? Mark my post as a solution!
arb1782Helper III
Helper IIIHi 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