'Conditional formatring x-axis power bi

I'm trying to color the x-axis ticks on a bar chart. The name of the 3 worst bars should by displayed as red. enter image description here

In this picture, this should be Envelops, Labels and Fasteners

I tried the following:

RANKX(
    FILTER(
        ALLSELECTED(superstore[Sub-Category]),CALCULATE(SUM(superstore[Sales])>0)),
        CALCULATE(SUM(superstore[Sales])),,ASC)


VAR bottom3 =
IF(
    rang < 4 , 
    "#FD625E",
    "#F1F2F7")

RETURN
bottom3

and if i look at the result in a table:

enter image description here

it seems to make sense. However when i use the measure for conditional formatting in x-axis, it does not work. All ticks are still white



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source