Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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