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 basic matrix with names as rows, past 30 days as colums and count of closed cases as values. However, the dates don't appear in the right order.
As for now they are:
I have created the dates with the following code:
Calendar = ADDCOLUMNS ( CALENDAR (DATE(2016;1;1);TODAY()); "ShortDate"; FORMAT ( [Date]; "d mmm"))
If I instead use Date (the date hirarchy) everyting is in order, but then I can't pick a format that is sutable for my columns.
Solved! Go to Solution.
Hi @Anonymous ,
You can create a new calculated column :
Number = MONTH('Calendar'[Date])*100+DAY('Calendar'[Date])
Then select the ‘ShortDate’ column—Sort by Column-Number in the Data View. Results are as follows:
Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
You can create a new calculated column :
Number = MONTH('Calendar'[Date])*100+DAY('Calendar'[Date])
Then select the ‘ShortDate’ column—Sort by Column-Number in the Data View. Results are as follows:
Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |