Forum Discussion

RameshPachunuri's avatar
RameshPachunuri
Microsoft Employee
6 years ago
Solved

Color apply horizontally

How do we apply color in horizantal way like Row wise? For example we have a table shown below and it has values from Col1 to 5 and I want to apply the color variations based on the value like if it ...
Need Help
  • RameshPachunuri's avatar
    RameshPachunuri
    6 years ago

    Thank you for your repsonse.

    It seems in your col2 to 5 are coming from seperate columns. But myside columns data is coming from single column from Tabl as shown below.

    Here I am splitting the values based on Column1 and DateTime then showing in the matrix as shown below. Then I want to apply colors in Matrix tables based on Max, min and Middle values with respect to Column1 and DateTime columns. Please let me know how can we achieve this?

  • v-frfei-msft's avatar
    v-frfei-msft
    6 years ago

    Hi RameshPachunuri ,

     

    Here we go.

     

    Measure = VAR MAXV = CALCULATE(MAX('Table'[Column 2]),ALLEXCEPT('Table','Table'[Column 1]))
VAR MINV = CALCULATE(MIN('Table'[Column 2]),ALLEXCEPT('Table','Table'[Column 1]))
RETURN
IF(SUM('Table'[Column 2]) = MAXV , "Red", IF(SUM('Table'[Column 2]) = MINV,"Green", "Orange"))

     

     

    Pbix as attached.

     

TomMartens's avatar
TomMartens
Super User
6 years ago

Hey,

 

from your table it looks like the columns Column2 to Column5 contain numerical values.

If your are able to convert these columns into an attribute / value  combination meaning (converting a wide table format into a long table format), e.g by using the Unpivot function from Power Query:

https://support.office.com/en-us/article/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f588221c7098

, you can apply the conditional formatting  also row-wise.

 

Hopefully this provides you with a new idea, to tackle your challenge.

 

Regards,

Tom