Create colors based on value, not category

Hi jaryszek ,
You can follow these steps to implement it
1. Model MeterCategory and MeterSubCategory in a proper dimension (unique keys) and use those on visuals instead of the fact columns.

2.Create Rank Measure 

DAX 
Rank (Current Axis) :=
VAR RankTable =
    SWITCH (
        TRUE(),
        ISINSCOPE ( Dim_Meter[Subcategory] ),
            ALLSELECTED ( Dim_Meter[Subcategory] ),
        ISINSCOPE ( Dim_Meter[Category] ),
            ALLSELECTED ( Dim_Meter[Category] ),
        -- Fallback when neither is on the visual
            ALLSELECTED ( Dim_Meter[Category] )
    )
RETURN
IF (
    ISEMPTY ( RankTable ),
    BLANK(),
    RANKX (
        RankTable,
        CALCULATE ( [Total Amortized Cost] ),   -- ensure row→filter context
        ,
        DESC,
        DENSE
    )
)

3. Create Color Measure

DAX 
Color by Rank :=
VAR r = [Rank (Current Axis)]
RETURN
SWITCH (
    TRUE(),
    ISBLANK ( r ) || r > 5, "#B3B3B3",
    r = 1, "#E81123",
    r = 2, "#107C10",
    r = 3, "#0078D4",
    r = 4, "#FFB900",
    r = 5, "#8E8CD8"
)

4. Fact columns on the axis → duplicates can break ranks. Prefer a dimension.
• Top N visual filter → still works because we rank on ALLSELECTED; the Top N is applied after ranking, but the color measure is evaluated per visible item.
• Totals → ISINSCOPE prevents totals from getting a misleading rank; they’ll render as grey.
• Row-level security → honored automatically because we keep ALLSELECTED.

⭐Hope this solution helps you make the most of Power BI! If it did, click 'Mark as Solution' to help others find the right answers.
💡Found it helpful? Show some love with kudos 👍 as your support keeps our community thriving!
🚀Let’s keep building smarter, data-driven solutions together!🚀 [Explore More]

Hi jaryszek 

Visual calculations are a convenient way of handling this.

See this article for example:
https://www.sqlbi.com/articles/using-visual-calculations-for-conditional-formatting/

The nice thing about visual calculations is that the same calculation works regardless of the field on the vertical axis.

In your case, I would

1. Add this visual calculation for both bar charts:

Color by Rank =
VAR r =
    RANK ( DENSE, ORDERBY ( [Sum of CostInBillingCurrency], DESC ) )
RETURN
    SWITCH (
        TRUE (),
        ISBLANK ( r ), "#B3B3B3",
        r > 5, "#B3B3B3",
        r = 1, "#E81123",
        r = 2, "#107C10",
        r = 3, "#0078D4",
        r = 4, "#FFB900",
        r = 5, "#8E8CD8"
    )

2. Hide the visual calculation

3. Format > Properties > Data format > Set Color by Rank's Data Type to Text

4. Bars > Color > Conditional Formatting > Field value based on  Color by Rank

Does this work for you?

The problem with the Rank (Current Axis) measure is that in DAX SWITCH and IF cannot return table values. The other reply doesn't appear to take this into account.