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 was asked to re-create in Power BI a tabular report where the dates have been manually manipulated. The data is derived from a SharePoint list with limited fields. The list contains a month and week of projected and actual billed hours. I have built a custom calendar and linked it to Create Date however, the report is not driven by that date field so it doesn't help and my only real issue is in getting the "for Month" to sort in my visual.
Here is the original report:
My version in Power BI
Here is my calendar
Solved! Go to Solution.
You need to create a sort column and mark that as sort column
Month Year = FORMAT([Date],"mmm")
Month Year sort = FORMAT([Date],"mm")
Mark Month Year sort as sort column of Month Year
How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c
Thanks for the idea but my calendar was hosing things up so I took it out of the mix, used the Create date from SharePoint and then created sort on that date. As always...I appreciate this community!!!
You need to create a sort column and mark that as sort column
Month Year = FORMAT([Date],"mmm")
Month Year sort = FORMAT([Date],"mm")
Mark Month Year sort as sort column of Month Year
How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c
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 |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |