Forum Discussion
jcamilo1985
Helper III
Helper IIIconditional formatting by row
A cordial greeting to all I think that for some this topic will be familiar even very simple, but even so I have not managed to get the solution, I have no choice but to ask for your help. I have a...
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
