Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi @Anonymous,
If your model has sales table data and an order date you can achieve your result by using the sales sum and the date as shown below:
Ideally you should have a Date table in your model connecting to your sales table.
Within this Date table you can create a column to capture the beginning of the week using this code by @TomMartens https://community.powerbi.com/t5/Desktop/Week-commencing-in-DAX/td-p/241304
Then drag your SoW date and Sales Amount as shown in the image. The sales will sum by the date.
I have attached this example using the Northwind database for you to try.
If this is not what you require, please post sample of your data and follow this article so another community member can answer your question.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Maria
Create a column chart and put Week order date in Axis and Sum sales in value.
Hi ,
I tired but not woring.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!