Forum Discussion
coloring graph based on buckets
Hello everyone,
I am working on sample project and I am trying to color he graph based on sum of percentage. But I can't figure out how to do it. Can anyone please help me out.
I have attached the graph I am trying to replicate. I have slot hold and slot machine performance columns. I created a new column " Percentage of slot holds" and use color saturation to change the colors of the graphs, but unable to create buckets and change the color of the graphs by assigning the colors to the buckets.
Hopefully these are the links you are looking for:
https://exceleratorbi.com.au/conditional-formatting-power-bi/
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting
9 Replies
Hi Anonymous,
It seems that you want to find this option for changing the color of the graphs. If you have a field under Color saturation, you could find Diverging option under Data color format.
Best Regards,
Cherry
Hi v-piga-msft,
Thanks for the respnose, I did that but I want to color the graph based on the sum of percentage.
Example if sum of percent is between 0-20% i want it to be light yellow and if it is between 20-40% i want it to be different color and so on.Is there anything I can do for this.
Thanks and Regards,
Jyothi
Anonymous Don't think so. Can you do it for a matrix tho by coloring based on alternate value. So perhaps they will introduce it soon for other visualizatons.
Seward12533 I tried for matrix based graph but still have troble doing it.
Is there any link that can explan me how to do it for matrix based graph atlease.
Any help is appreciated.
Thanks,
Jyothi
