Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
I have a requirement to show sales ratios for every month in the given quarter and the total value in the same line of the line graph. Something like this:
I know it does not make sense to show individial months and the quaterly value in the same line. But this the requirement. Any idea on how to do this?
Solved! Go to Solution.
Hi,
Quite peculiar request, here is one way to do this:
Test data:
1. Add the following column to your calendar table:
2. Measure:
End result:
If you want to add also year to your x-axis modify the column in calendar.
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
Proud to be a Super User!
Thanks man, worked like a charm.
Hi,
Quite peculiar request, here is one way to do this:
Test data:
1. Add the following column to your calendar table:
2. Measure:
End result:
If you want to add also year to your x-axis modify the column in calendar.
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
Proud to be a Super User!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
21 | |
17 | |
16 | |
11 | |
7 |
User | Count |
---|---|
26 | |
25 | |
12 | |
12 | |
12 |