Individual column conditional formatting in matrix

[Benkov]

Hello!

I have a seemingly unsolvabe task i need help with.

I have a matrix visual that looks like this:

The values are calculated by a measure, hence the use of a matrix.

The column and row headers are from two different tables, but they are connected via additional tables.

I want to format the columns one by one so it highlights values that are below the individual "Target" values:

Is there a way to accomplish this?

I tried looking into solutions everywhere, but they are not even close to what i need.

Any help would be appreciated.

Thank you in andvance!

[vojtechsima]

Hi, @Benkov 
You can apply conditional formatting based on value and that value is this measure:
99.80 is your  target, you can put whatever you want , same for color I put red and black, but you can put there any color.

If([YourMeasure] < 99.80, "#F00", "#000")

[Benkov]

Thank you for your reply!

As you can see on my previous pictures, i have multiple different values in my "Target" row, and your suggestion only works with one given value.

(there was some language barrier induced misunderstanding on my side)

As far as i know i cannot use it on individual columns in my matrix, because only one measure is allowed to fill the entire matrix with values without duplicating all cloumns.

[Anonymous · Accepted solution]

Hi @Benkov ,

Accroding to your screenshot, I think there should be at least [Group] columns in both tables. So I think you just need to calculate target in each group and compare [value measure] with the target in each group to get the color.

My Sample:

Relationship:

Measure:

Measure = 
VAR _TRAGET = SUM('Column'[Target])
RETURN
IF([Value(Measure)]<_TRAGET,"Red")

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.