Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Individual column conditional formatting in matrix

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!

 

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    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.

3 Replies

  • vojtechsima's avatar
    vojtechsima
    Super User
    4 years ago

    Hi, Anonymous 
    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")

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi Anonymous ,

         

        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.