Forum Discussion

mogugu_84's avatar
mogugu_84
Helper I
1 year ago

conditionally formatting by column

Hi  i hope to create a conditionally formatting based on individual column of the matrix table below (preferrably gradient color scale), i.e. 3M within product P, not 3M across both Product P and Pr...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi mogugu_84 ,

As he said, for a customized format for a specific Value in the matrix, you can first determine under which column classification it is located, in the data you provided for Molecule.You can view the following pbix file. If it still doesn't solve your problem, you can provide the full example data and MEASURES, preferably the example pbix file, so we can help you faster.Please hide sensitive information in advance.

 

Best regards,
Albert He

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

mogugu_84's avatar
mogugu_84
Helper I
1 year ago
Thank you, the example file you provide is helpful, but i still couldn't get it right...
 
Tried to replicate from your "Color" measure to mine as below, did i get it right? the aim is to compare to the total value of "3M G%" under Product P, i.e. if it's greater than 15.3%, color green, if below, orange, if negative, red
 
Color =
IF(
    SELECTEDVALUE('Def market'[Molecule]) <> "Product P",
    "No color",
    IF(
        [3M Growth] < 0.15 ,
        "Red",
        "Green"
    )
)
 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi mogugu_84 ,
    You can try this code

    Color =
IF(
    SELECTEDVALUE('Def market'[Molecule]) <> "Product P",
    "No color",
    IF(
        [3M G%] < 0 ,
        "Red",
        IF(
           [3M G%] <= 0.153,
           "Orange",
           "Green"
        )
    )
)

     

    Best regards,
    Albert He

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

     

     

     

    • mogugu_84's avatar
      mogugu_84
      Helper I
      1 year ago

      thank you, anyway i can make this number dynamic, instead of put it as 15.3%?

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        Hi mogugu_84 ,
        Sure. You can replace it with measure which you want to compare.

        Best regards,
        Albert He

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