Forum Discussion
PowerBi table | Conditional formatting per line
Dear forum, We are trying to visualize the change in margins per kg or prices per month by product group with a color gradients (red/yellow/green). The columns should show month.year, the lines the ...
| Feb 2022 | Mar 2022 | Apr 2022 | May 2022 | Jun 2022 | Jul 2022 | |
| Product 1 | 1,20 | 1,60 | 1,15 | 1,18 | 1,30 | 0,90 |
| Product 2 | 9 | 11 | 6 | 6 | 7 | 8 |
| Product 3 | 21 | 30 | 27 | 19 | 25 | 22 |
| Product 4 | 2,3 | 2,8 | 2,9 | 2,1 | 4 | 4,1 |
Attached a dataset, we would need to have gradient color per line, so would mean for Product 4 - 4,1 dark green, 2,1 red
Hope this helps:
Colour =
SWITCH(TRUE(),SELECTEDVALUE(Data[Product])="Product 4" && SELECTEDVALUE(Data[Amount])>=4,"Dark Green",
SELECTEDVALUE(Data[Product])="Product 4" &&( SELECTEDVALUE(Data[Amount])>=2.5 && SELECTEDVALUE(Data[Amount])<4),"Yellow",SELECTEDVALUE(Data[Product])="Product 4" &&( SELECTEDVALUE(Data[Amount])>=MIN(Data[Amount]) && SELECTEDVALUE(Data[Amount])<2.5),"Red")
For this to work, all your dates should be in one column and amount should be in a separate column in the table. If it is not so, in the table, you may have to unpivot the month-year columns.
If you are unfamiliar with unpivoting, you may watch this screen-recording