Forum Discussion

njxfoster's avatar
njxfoster
Icon for Helper I rankHelper I
3 years ago
Solved

Adding description to time measure

Hi Guys 

 

I have set a weekending measure to show the week starting date vs. the week ending date

 

For X-axis, is there a way I can change the display from showing "November 20" to " Week of 11/20"? 

 

 

Thanks in advance!

 

Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi  njxfoster ,

    I created some data:

    Here are the steps you can follow：

    1. Create calculated column.

    Week = WEEKNUM('Table'[Date],2)
    mindate =
var _weeknum=WEEKNUM('Table'[Date],2)
var _weekday=WEEKDAY('Table'[Date],2)
return
MINX(FILTER(ALL('Table'),'Table'[Week]=EARLIER('Table'[Week])),[Date])
    Flag = "Week of" &" "& MONTH('Table'[mindate])&"/"&DAY('Table'[mindate])

    2. Add Column – Index Column – From 1.

    3. Create calculated table.

    Table2 =
SUMMARIZE('Table','Table'[Flag],"Index",MINX(FILTER(ALL('Table'),'Table'[Flag]=EARLIER('Table'[Flag])),[Index]))

    4. Join the relationship between two tables.

    5. Column[Flag] – Column tools – Sort by column -- [Index] .

    6. Result:

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi  njxfoster ,

    I created some data:

    Here are the steps you can follow：

    1. Create calculated column.

    Week = WEEKNUM('Table'[Date],2)
    mindate =
var _weeknum=WEEKNUM('Table'[Date],2)
var _weekday=WEEKDAY('Table'[Date],2)
return
MINX(FILTER(ALL('Table'),'Table'[Week]=EARLIER('Table'[Week])),[Date])
    Flag = "Week of" &" "& MONTH('Table'[mindate])&"/"&DAY('Table'[mindate])

    2. Add Column – Index Column – From 1.

    3. Create calculated table.

    Table2 =
SUMMARIZE('Table','Table'[Flag],"Index",MINX(FILTER(ALL('Table'),'Table'[Flag]=EARLIER('Table'[Flag])),[Index]))

    4. Join the relationship between two tables.

    5. Column[Flag] – Column tools – Sort by column -- [Index] .

    6. Result:

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

  • njxfoster's avatar
    njxfoster
    Icon for Helper I rankHelper I
    3 years ago

    Hi Guys 

     

    I have set a weekending measure to show the week starting date vs. the week ending date

     

    For X-axis, is there a way I can change the display from showing "November 20" to " Week of 11/20"? 

     

     

    Thanks in advance!

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Yes but I don't believe it would ever be recommended.

       

      The formula you have utilises data type Date or Date/Time. This maintains chronological settings.

       

      You could create a custom column using the following code:

      WeekOf = "Week Of " & FORMAT([WeekEnding], "mm/dd")
       
      This introduces a host of issues though relating to data control due to a change in data types. To put "week of" into a column means your data type changes to Text. You will lose chronological control and your columns will be shown alphabetically (or alphanumerically based on the digit assignment). The only real way to control this would then be to create a separate table that has a ranking column next to it so you could list them in the order you want to.
       
      If this is due to user preference then education/expectations management is key.