coloring graph based on buckets

[Anonymous]

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.

[v-piga-msft]

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

[Seward12533]

@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.

[Anonymous · Accepted solution]

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

[Anonymous]

@Anonymous Thank you.

[Anonymous]

@Anonymous if this is the required solution could you mark it as one.

[Anonymous]

@Anonymous the solution is helpful, but its not exactly what I am looking for here. I wanted to know how to perform conditional formating for bar graphs.

Regards,

Jyothi.

[Seward12533]

Feature is not currently available but based on what I say previewed at the MS BI summit may be available soonish. They will be rolling out Dax controlled formatting visual elements. Some of the first will be Dynamic Titkes for visuals. Not sure when coloring of bars will be included.

There are a number of ideas on this including this one. Vote or post a more specific idea and share a link and I’ll give it mine.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/6518993-set-colors-and-conditiona...

[Anonymous]

@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

[Anonymous]

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