Custom formatting of x-axis groups for 100% Stacked column charts

[rhiheu]

Hi,

For my 100% Stacked column chart, I have a group of products grouped by date, along the x-axis. Is there a way I can custom format groups to be different from each other?

A. My first preference would be to alternate the background colour of each group, e.g.

B. But if that's not possible, if I could atleast bold or colour today's date group that would be great, e.g.

I've gotten as far as the custom column to change the formatting of today, which works on a table:

TodayFormatting = IF(KronosWithBothGroups[date] = TODAY(), "green", "white")

But when I try and apply it in the x-axis > Values formatting, it turns everything green, I'm not sure how to apply the formatting to only one (or some) date groups:

Any help appreciated, thanks.

[rhiheu]

Hi @chrisyan_manalu, thanks for your reply. I've added that formula (to a new column called 'TodayInteger') and I can't seem to get it to work to change the background colour to green even on the table:

[chrisyan_manalu]

@rhiheu it's looks like your data type of TodayInteger is text

Please change it to number  

[rhiheu]

Oops, you're right, sorry about that. I've changed it to number and it now works on the test table (with max, not sure if that's the best option?)

However unfortunately it doesn't seem to work on the X-axis > Values formatting of the 100% stacked column chart, it's colouring everything:

[chrisyan_manalu]

@rhiheu if you dont mind, you can chage the custom column to integer.

TodayFormatting = IF(KronosWithBothGroups[date] = TODAY(), "1", "0")

And you can make conditional formating using rule format which if value equals to 1 then green (colour code)