Conditional Formatting Matrix Columns

I found this thread looking for the same conditional formatting color scale "per column".

I thought I was close using RankX to get the format key below, but that still didn't work.

I think that I've found an answer in this youtube video.. https://www.youtube.com/watch?v=wTRrskQzAHk

He brings it together at the end, and it looks to work in my scenario.

__PerMonthColorScale = 
    VAR SummaryTable = 
        CALCULATETABLE(
                ADDCOLUMNS(
                    SUMMARIZE(
                        Forecasts,
                        Projection_Master[JOBNUMBER_I],
                        Forecasts[TargetMonth]      
                ),
                "CurrentProjection", [Current Projection]
            ), 
            ALLSELECTED('Job Summary')
        )
    VAR MaxValue = 
        MAXX(
            SummaryTable,
            [CurrentProjection]
        )
    VAR MinValue = 
        MINX(
            SummaryTable,
            [CurrentProjection]
        )
    VAR Range = MaxValue - MinValue
    VAR Hue = 
        Round(
            DIVIDE(
                [Current Projection] - MinValue,
                Range
                ) * 120,0)
    VAR Color = "hsla(" & Hue & ", 100%, 50%, 1)"
    RETURN
        if (ISBLANK([Current Projection]),
            BLANK(),
            color
        )

Hello,

I am trying to figure out if there is a way to use conditional formatting to go on the basis of the column, rather than the entirety of the matrix.

For example, when I use the Lowest value to Highest value format, it will compare the values of the whole table, when I’d like the conditional formatting to compare lowest to highest of only the values in columns.

Thank You for your help,

Hello,

Does anyone know if there is already a solution for the question asked?

Thank you for your help,

If anyone else stumbles across this like me, I voted for this idea

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/33844120-conditional-formatting-on-column-values-based-on-v

For anyone searching, the below works:

Formatting Measure =
RANKX (
    ALLSELECTED ( Matrix Rows ),
    [Matrix Measure],
    [Matrix Measure],
    ASC
)

I don't understand why the measure is in there twice, or what it's doing. But I know it works.

If you have a very narrow range of values, the highlighting effect won't be very pronounced.

FYI this can be done in Tableau

To attain this objective, utilize conditional formatting that relies on the proportion of a measure's contribution to the overall total, rather than the raw measure itself. This ensures that the column formatting is determined by values always ranging between 0 to 1, as depicted in the image.

The dax for achieving this is as follows: