Forum Discussion
conditional formatting by row
Hello jcamilo1985,
I’ve successfully implemented the following steps:
- Created a custom column to calculate the sum of all columns.
- Created a custom column to compute the ratio of each column's value.
- Created a custom column for each ratio's corresponding hexadecimal color.
- Applied conditional formatting using the hex values generated from the ratios.
If you're interested, please let me know, and I'd be happy to share the PBIX file with you. The only limitation of my solution is that, as shown in the diagram, it currently only works for negative values. The intensity of the red color decreases as the negative value increases, which is the opposite of what you need.
DivKlearner, A bit forward daily.
Link to my channel on Power BI.
https://www.youtube.com/watch?v=aADx2sPA2D0&list=PLDUIC70xSiVQQpfqGhOjBVDF8IBP2k6ob
Hello jcamilo1985,
I’ve successfully implemented the following steps:
- Created a custom column to calculate the sum of all columns.
- Created a custom column to compute the ratio of each column's value.
- Created a custom column for each ratio's corresponding hexadecimal color.
- Applied conditional formatting using the hex values generated from the ratios.
If you're interested, please let me know, and I'd be happy to share the PBIX file with you. The only limitation of my solution is that, as shown in the diagram, it currently only works for negative values. The intensity of the red color decreases as the negative value increases, which is the opposite of what you need.
DivKlearner, A bit forward daily.
Link to my channel on Power BI.
https://www.youtube.com/watch?v=aADx2sPA2D0&list=PLDUIC70xSiVQQpfqGhOjBVDF8IBP2k6ob