Forum Discussion
Condition formation per month column
Dear Experts I Am try to format each coulmn in power bi matrix based on the max to min value as gradient color. I did my best and the result not coming as expected. My matrix inlcude monthes and per...
I would like to know if someone has ever done the highlighting of Min & Max value for each COLUMN in a matrix visual. I am able to find the max & min values for the entire matrix but not able to figure out a way to highlight the max & min for each COLUMN not row.
UPDATE
i found some one asked for same question but for row not column and when i tried it its work fine per row, but my target is to apply it on or per coulumn
Highlight Min & Max Values for each Row in matrix visual - DAX / DAX Calculations - Enterprise DNA ForumVAR Vals = CALCULATETABLE ( ADDCOLUMNS ( SUMMARIZE ( DIM_WON_ANALYTICS, 'Root'[Name EN], 'Services List'[Name EN], 'Date'[UNMMAE] ), "@SalesAmt", [Best Selling Product Value] ), //ALLSELECTED () ALL ( 'Date'[UNMMAE] ) ) VAR MinValue = MINX ( Vals, [@SalesAmt] ) VAR MaxValue = MAXX ( Vals, [@SalesAmt] ) VAR CurrentValue = [Best Selling Product Value] VAR Result = SWITCH ( TRUE, CurrentValue = MinValue, 1, -- 1 for MIN CurrentValue = MaxValue, 2 -- 2 for MAX ) RETURN Result