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.
Hi
I have a table that looks at when a review is due and when it is actually completed. Each person has multiple actual review dates and I want to sort them so they line up next to the due date. What I want to do is organise the earliest review date as review 1 then the next date as review 2 and so on. The bloew table is what I have so far, it is so I can compare if the actual review date was done before the due date. Hope that makes sense. Any help is greatly appreciated, thanks
hi, @Anonymous
I think you need to use the Sort by Column in power bi.
https://radacad.com/sort-by-column-in-power-bi
If not your case, please share your expected output in an excel, I'm sorry that I don't understand which in your screenshot.
Best Regards,
Lin
Thanks for the response.
Currently this is the output I get on BI
I want to organise the actual date in the end column so I get the below result so the actual first review can be put next to the 1st review due by. It would also be useful if the date would be green or red depending on if it is before or after the review due by date. Soemtimes 4 reviews may not have been completed so would that cause an issue. Hope that makes sense, thanks
hi, @Anonymous
Ok I know, Not sure if it could be achieved for your requirement,
Could you share a simple sample pbix file for us have a test? Just from the screenshot we couldn't see your data mode.
Best Regards,
Lin
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 |
---|---|
98 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |