Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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?
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
90 | |
83 | |
76 | |
64 |
User | Count |
---|---|
142 | |
112 | |
98 | |
98 | |
94 |