Forum Discussion

Narasimha's avatar
Narasimha
Icon for Helper I rankHelper I
9 years ago
Solved

Week formats

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  
Need Help
  • GilbertQ's avatar
    GilbertQ
    9 years ago

    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's avatar
Narasimha
Icon for Helper I rankHelper I
9 years ago

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's avatar
GilbertQ
Icon for Super User rankSuper User
9 years ago

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

  • Narasimha's avatar
    Narasimha
    Icon for Helper I rankHelper I
    9 years ago

    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's avatar
      GilbertQ
      Icon for Super User rankSuper User
      9 years ago

      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's avatar
        Narasimha
        Icon for Helper I rankHelper I
        9 years ago

        Can i have sample DAX formual?