ta

I have attached sample data .  i trying to  achieve color code every cell in table but in Power bi conditional formating only two options color by scale and rules .

i am trying to achieve like below 

Next tap  i want to get total values 

how to get total in column graph . 

i have attached sample PBI for reference 

Sample Link : https://gofile.io/d/AbNAjw

please help me . thanks in advance