Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi
I have data for new customers joining courses by date and want to show it in months, across years. For example Jan-20 to Feb-21.The issue is, then I have the date grouped into "Year and month" in the Axis, it just shows 12 months, and essentially will combine Jan-20 and Jan-21 dates into "January" etc for other months.. as below... Ideally I want it to shows Jan-20 to Dec-20, then carry on with Jan-21 to Dec-21
I really dont know how to accomplish this any help would be much appreciated
Thanks
Chris
Solved! Go to Solution.
@cwilliams2109 , I mean separate column. But in this case too, expand using the Reverse Y icon and try
Hi @cwilliams2109 ,
I think the “reverse Y” mentioned by amit refers to the following icon.
Hope that's what you were looking for.
Best Regards,
Yuna
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @cwilliams2109 ,
I think the “reverse Y” mentioned by amit refers to the following icon.
Hope that's what you were looking for.
Best Regards,
Yuna
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@cwilliams2109 , Drag both month and year to Axis, Sort on them, and drill levels. And Switch of Contactenate labels
Hi
When you say drag month and year..... Do you have to have a seperate "Month" and "Year" column of data? I am just using 1 field of "Referral Date" and dont have seperate fields.
So it looks like this
@cwilliams2109 , I mean separate column. But in this case too, expand using the Reverse Y icon and try
Sorry what is the "Reverse Y" icon?
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
91 | |
87 | |
84 | |
68 | |
49 |
User | Count |
---|---|
131 | |
110 | |
96 | |
70 | |
67 |