Display or highlight the current weeknumber in a barchart

[Rick_T]

Goodafternoon, 

Is there a way to display or highlight the current weeknumber in a barchart when it is containing all the 52 weeks in a year? 

Sincerely, 

Rick 

[p_verkooijen · Accepted solution]

Yes use color by Expression

IF(Week=WEEK(Today()), Green(), Blue())

Where Week = your calendar dimension containing the weeknr

[Rick_T]

Works great! 

Thank you very much 🙂 

[rbartley]

Alternatively, you could use a combo chart and have the second measure displayed as a marker

only for the current week number, e.g. 

If( Week = WEEK(Today),Sum(Measure))