Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I've been trying to implement a solution to no avail. Your brilliant suggestions are appreciated.
I am using the latest PBI Desktop in direct query mode. I have a column called "Week Due Bucket" where all dates before a certain day are lumped into a field called "Past Due" and any dates in the future use their literal date, based on the Sunday of that week. I had to create a text column in order to store "past due" in the same column as the dates. I can't use FORMAT with DQ, so I had to do:
Matrix visual preview, Week Due Bucket as column, unsortable:
Solved! Go to Solution.
Hi @Anonymous,
As you are using Direct query, So you should edit your data in the data source to change the data type. Here we cannot change the sort in Power BI side directly. Or we can import the data and edit the data model in PQ to achieve our goal.
Regards,
Frank
Hi @Anonymous,
As you are using Direct query, So you should edit your data in the data source to change the data type. Here we cannot change the sort in Power BI side directly. Or we can import the data and edit the data model in PQ to achieve our goal.
Regards,
Frank
Hi @Anonymous,
Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.
Regards,
Frank