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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch 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
ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.