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
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
