I have a matrix and bar chart visual showing data for a short period of days. When It is a new month combined with days from the last month the order gets messed up. Im trying to show it its true order and havent found any information that has worked for me yet.
In this visual the 1 is february 1st but the rest of the numbers are from january. How do I get the 1st after the 31st while still showing the data by day and not totals for the month.
You can add a column to your date table that hold the date (1/1/2023) but is formatted to display the day (dd). I was not able to get it to work uness formatting it as dd which show the leading 0 (01, 02, etc) but other than that it works.
You can see I am showing only Feb 17th - Mar 1st and it is keeping the March 1 (01) on the end because it is sorting by the actual field value (3/1/2007) but displaying the formatted value:
You can add a column to your date table that hold the date (1/1/2023) but is formatted to display the day (dd). I was not able to get it to work uness formatting it as dd which show the leading 0 (01, 02, etc) but other than that it works.
You can see I am showing only Feb 17th - Mar 1st and it is keeping the March 1 (01) on the end because it is sorting by the actual field value (3/1/2007) but displaying the formatted value:
Helpful resources
Fabric Community Update - July 2025
Find out what's new and trending in the Fabric community.
Power BI Monthly Update - July 2025
Check out the July 2025 Power BI update to learn about new features.
