Bar Chart Visualization - Question about Dimension Display

[jerryr125]

Hi everyone !

I have a question regarding the Bar Chart visualization.

I am presently display on the X-Axis the Year-Week Number (calculated on the data load).

The Y-Axis displays the value.

The visualization works prefect!

Question: Is there a way on the chart to highlight the current Year-Week Number - either the X-Axis and/or the Bar itself ?

Example: For this week (2022-18) display the bar a different color (say Hex #D90416) AND all of the other bars on the chart are displayed as  HEX #0f9D58.

Any thoughts ?  thanks - Jerry

[vchuprina · Accepted solution]

Hi,

You can do it in the following way:
1. Open chart settings
2. Select Appearance
3. Select Colors and legend
4. Switch Colors to Custom and select By expression in the dropdown list
5. Use expression
IF(Week = Year(Today())&'-'&Week(Today()), '#D90416', '#0f9D58')
Note that check box 'The expression is a color code' should be checked.

Regards,

Vitalii