Trying to conditionally format per heirarchy level.

[mabCOLONEL]

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 will base the color on the entire column value.  I am not great with measures as of yet, so this is a learning process.  I know the screen shot is a poor example, but assume the values in the far right column are not always the same.  So I would like to format the levels independantly of each other where noted group 1 will format independantly of group 2.  

Thank you in advance. 

[v-yadongf-msft]

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]

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. 

[amitchandak]

@mabCOLONEL , You can use isinscope and and create a color measure and use that in conditional formatting using field value option

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/

How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/...
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pan...