Forum Discussion
Helper IWeek formats
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.
Super UserHi 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.
Helper IThanks 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?