Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
Anonymous
Not applicable

Created week name wise sales in tableau,how to create same in power bi,please help on this issue.

weekname wise.PNG

4 REPLIES 4
MariaP
Solution Supplier
Solution Supplier

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:

SalesByBeginningOfWeek1.PNG

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.

NorthwindSalesByStartOfWeek

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

Anonymous
Not applicable

Create a column chart and put Week order date in Axis and Sum sales in value.

Anonymous
Not applicable

Hi ,

I tired but not woring.

Hi @Anonymous,

If you need further help please provide either a sample of your pbix file and your data , along with what you have tried so the community can understand the problem to assist.

Thank you,
Maria

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

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.

Top Solution Authors
Top Kudoed Authors