Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello everyone,
I want to sort below month'Year in asending order.
I am not able to sort. please help on this.
Used already-Created monthNo & sorted on and got result correct for only year but not for more than 1 year as it has more than 1 year like in above view .
I don't have to plot year above month row in view.
Thanks
Shiv
Hello @Anonymous ,
Create MonthYearInteger column
MonthYearInteger =
Hi Tarun,
Thanks for reply
I have done this by this way
Created one column
Hi Tarun,
I have done this using @amitchandak post. but thanks for reply you r also corect
@Anonymous
You need to create the sort column including the year, modify monthno column as follows, and sort by that:
YearMonth = YEAR(Dates[Date]) * 100 + MONTH(Dates[Date])
________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Thanks for reply
I have done this by this way
Created one column
User | Count |
---|---|
41 | |
27 | |
23 | |
18 | |
15 |
User | Count |
---|---|
54 | |
35 | |
19 | |
18 | |
15 |