Forum Discussion

damit23183's avatar
damit23183
Icon for Microsoft Employee rankMicrosoft Employee
3 years ago
Solved

Display Alternate week number only

Hi,   I am working on column chart where I would like to only show alternate week number in graph,   I have this now; However, I would like to see like this; As you see I dont want ...
Need Help
  • damit23183's avatar
    damit23183
    3 years ago

    No, it didn't resolve but convinced my client to choose to other way.

    Thanks for reaching out.

kunal15sep's avatar
kunal15sep
Frequent Visitor
3 years ago

Add a calculated column:

 

var _weeknum= WEEKNUM(DATE[DATE])

 

RETURN

IF(_weeknum%2==1,1,0)

 

Use desire weeknum in visual filter of the chart