Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Yes use color by Expression
IF(Week=WEEK(Today()), Green(), Blue())
Where Week = your calendar dimension containing the weeknr
Yes use color by Expression
IF(Week=WEEK(Today()), Green(), Blue())
Where Week = your calendar dimension containing the weeknr
Works great!
Thank you very much 🙂
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))