Forum Discussion
Apply conditional formating to several values based on the highest number
GOGIANTS in your case, you are adding seperate columns in values field that is why you have to apply conditional formatting seperatly for each columns. I suggest you to combine all these values into one columns using unpivot data feature in power query and then use that column in the value field. this can solve your problem. UnPivoting the data is very easy in power query, you select all columns and then unpivot option. This value create two columms, one for value and second for type of value.
hope this solution solve your issue. thanks
I found the solution, instead of pivot i should unpivot the column which turned it into one value. Thanks for guiding in the right direction!
Community ChampionGOGIANTS what is the conditional that you wish to apply to your data. on what basis color formatting to be applied?
With excel I just used the standard one (RED = HIGH, GREEN = LOW).
- negi007
GOGIANTS in your case, you are adding seperate columns in values field that is why you have to apply conditional formatting seperatly for each columns. I suggest you to combine all these values into one columns using unpivot data feature in power query and then use that column in the value field. this can solve your problem. UnPivoting the data is very easy in power query, you select all columns and then unpivot option. This value create two columms, one for value and second for type of value.
hope this solution solve your issue. thanks
My thought was also to pivot the table but somehow this isnt working. when i select the columns which i would like to pivot, the button is "grey".
I found the solution, instead of pivot i should unpivot the column which turned it into one value. Thanks for guiding in the right direction!