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 ...
Hey Padycosmos , this is not really helpful I believe....we would need to calculate an %-value for each line based on the min / max and base a measure on this value (similiar to the linked article but for lines, not for rows)
https://medium.com/creative-data/power-bi-conditional-formatting-by-rows-8ce6187e25c6
Would you be able to share the pbix file?
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
