Forum Discussion
Solved
Determine Minimum and Maximum Value in Row in Matrix
Hi I am relatively new to power bi I have a dataset that looks as follows Country Supplier Value A Acme 10 A Illuminati 12 A Batman 14 B Acme 20 B Illumi...
Hi,
You can use a MEASURE to do the conditional formatting
Measure = VAR mymin = CALCULATE ( MIN ( Table1[Value] ), ALL ( Table1[Supplier ] ) ) VAR mymax = CALCULATE ( MAX ( Table1[Value] ), ALL ( Table1[Supplier ] ) ) RETURN SWITCH ( TRUE (), SUM ( Table1[Value] ) = mymin, "#FF7F00", SUM ( Table1[Value] ) = mymax, "#2AAAFF" )Now in the Conditional Formatting dialogue
Select as follows
Zubair_Muhammad
Community Champion
Community Champion
Hi
I would like to display a seperate matrix or table layed out as follows
| Supplier | Lowest Values | Highest Values | Total Values |
| Acme | 2 | 1 | 3 |
| Batman | 1 | 1 | 3 |
| Illuminati | 0 | 1 | 3 |
- Zubair_Muhammad
You can add these calculated columns
Please see revised file as well
Highest = VAR temp = MAXX ( FILTER ( table1, [Country] = EARLIER ( Table1[Country] ) ), [Value] ) RETURN IF ( [Value] = temp, 1 )Lowest = VAR temp = MINX ( FILTER ( table1, [Country] = EARLIER ( Table1[Country] ) ), [Value] ) RETURN IF ( [Value] = temp, 1 )- arvindyadav
Post Partisan
Hi Zubair_Muhammad ,
In my case, the conditional format measure is not working while I am putting that measure in conditional format field value.
Thanks,
Arvind
