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 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
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 |
---|---|
111 | |
97 | |
82 | |
67 | |
61 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |