Week formats

[Narasimha]

Hi Team,

I want to display the visual like below

Instead of below

I want week starts from Monday to sunday..

How to do the same..

Thnaks in advance

[GilbertQ]

Hi @Narasimha

What I would suggest is to create a Date table, then create a relationship from your current table to the Date table.

Once you have the date table you will see that there are a whole lot of extra columns which you can use, or even create. After which you can then use any of those columns for your visual.

Power BI – How to Easily Create Dynamic Date Table/Dimension with Fiscal Attributes using Power Quer...

[Narasimha]

Thanks For the update guavaq..I was created Date table and created relationship b/w date table and our data table. 2nd visual  i was created using date table with below query

Week1 = CONCATENATE("Week-",WEEKNUM(DimDate[Date],2))

here in above dax, 2 means week starts from monday..

[GilbertQ]

That is great going, do you now have it in the format you require?

[Narasimha]

No.. I want to create Line chart using power bi desktop with below x axis date format instead of Week1, Week2,Week3

Note : Above visual was created using Excel

[GilbertQ]

Ok, so if you go back into the Query Editor you can add a new column where you can then create the values for each week as per your image into this new column.

Then you can use this column for your visual?

[Narasimha]

Can i have sample DAX formual?

[GilbertQ · Accepted solution]

Hi @Narasimha

If you go into the Query Editor and then the Date table.

Click on Add Column in the ribbon and then click on Custom Column, and give it a name.

Put in the following code below.

Date.ToText(Date.StartOfWeek([Calendar Date], Day.Monday),"MM/dd") & "-" & Date.ToText(Date.EndOfWeek([Calendar Date], Day.Monday),"MM/dd")

This will then create the column you require.

[Narasimha]

Hi @GilbertQ,

Am getting below error while trying to create new column in Date table. Could you please help me out.

[MarcelBeug]

You forgot to go into the Query Editor.

The code from @GilbertQ is Power Query (M), not DAX.