Forum Discussion
Solved
Power BI conditional formatting per column in Matrix
Hello, I have a matrix in PowerBI with rows item category, item description, the column Year and the values Sales before Returns, Returns in Euro and Returns Quotas. The data looks like this: Ar...
I found a Soulotion.
First, I calculated the Amount of Return.To get the Amount of Return per Year/per Column, I used this Measure:
Returns per year = DIVIDE(CALCULATE(Messure[Returns in Euro],ALLSELECTED(T1[ItemCategoryReference])),CALCULATE(Messure[Sales before Returns],ALLSELECTED(T1[ItemCategoryReference]),0)*100
To get the Return Ratio. I used this MeasureReturns ratio = DIVIDE(Messure[Returns in Euro],Messure[Sales before returns],0)*100
For the Color-Condion
Color 2 = if(Messure[returns rate]>Messure[returns per year], "red", "green")
I then used Color 2 as Field value in conditional formatting.Color2 = if(Messure[returns rate]>Messure[returns per year], "red", "green")
hy dont you use conditionneal formatting, it will be easier
Since it then refers to the entire matrix and not to the column.