Forum Discussion

mabCOLONEL's avatar
mabCOLONEL
Frequent Visitor
3 years ago

Trying to conditionally format per heirarchy level.

I have the matrix table as shown.  I wanted to conditionally format the highest to lowest number per column based on the hierarchy level only.  Currently, when I apply the conditional formatting, it ...
Need Help
v-yadongf-msft's avatar
v-yadongf-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi mabCOLONEL ,

 

This is my test table:

 

If you want to conditionally format the minimum value of different types of item in each group separately,

please create a new column as below shown:

 

Min_value of item = SWITCH(
    TRUE(),
    'Table'[Value] = MINX(FILTER('Table','Table'[Group] = EARLIER('Table'[Group]) && 'Table'[Type] = "Type1"),'Table'[Value]),"red",
    'Table'[Value] = MINX(FILTER('Table','Table'[Group] = EARLIER('Table'[Group]) && 'Table'[Type] = "Type2"),'Table'[Value]),"yellow")

 

 

 

 

Conditional formatting for value:

 

You will get a matrix visual like this which format the levels independantly:

Best regards,

Yadong Fang

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

mabCOLONEL's avatar
mabCOLONEL
Frequent Visitor
3 years ago

Thank you but I dont have just type 1 and type 2.  I have hundreds of items at that hierarchy level.  So a measure per 'type 1' vs 'type 2' is not going to be an effective solution.  Those 'types' can change names as well.