Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have created a date table for my benefits report and i have a column for which it will sort in FYmonth order
this is the relationship between the tables
and when i use the date in a table it 1 doesn't sort in FY month sort and doesn't le me show item with no data?
Solved! Go to Solution.
@abihoughton27 Hey Mate ,
You can create two Calculated col in your date tb.
Month sort = FORMAT(financials[Date],"yyyymmdd")
this will fulfil your requirement .
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Thanks and Regards,
Harish
Hi @abihoughton27 ,
Could you please share me with the expected output and your pbix file after removing sensitive data ?
Best Regards,
Eyelyn Qin
@abihoughton27 Hey Mate ,
You can create two Calculated col in your date tb.
Month sort = FORMAT(financials[Date],"yyyymmdd")
this will fulfil your requirement .
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Thanks and Regards,
Harish
@abihoughton27 you didn'n sort correctly the monthname to your FYmonthSort. Shouldn't Jan be 1, Feb be2 and so fourth?
@Applicable88 My financial month starts in may so i want that to be first - so it should be May - Jun 2 etc
@abihoughton27 Whats happens when you use "sort after column"? Does it says that you have many to many relationship?
Just click on your monthname column and tell it to "sorft after" the Monthnumbers.
I hope that solves your problem.
Best.
I have done that for my FY month sort because i want that to be the order? i am not sure what you mean?
there is no where in the image above which says sort after?
i want to sort from the fiancial year month sort not from the normal calander month order
The view I got from your screenshot actually. Its not in the PowerBi Report, but in the "Data" screen. That is the middle symbol on the left ribbon in PowerBi. Afterwards just select your table and click on the Monthname column, after wards click the button I showed you in the screenshot and say "sort after" Monthnumber column. Since your Monthnumber field is in the same table it should work.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |