Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
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.
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.
@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...
User | Count |
---|---|
119 | |
66 | |
66 | |
56 | |
50 |
User | Count |
---|---|
177 | |
84 | |
70 | |
64 | |
54 |