Chart color selection

[Statcom]

Hello,

I am looking to change the color of the categories in charts to the same colors as my theme without manually selecting the colors in the visualization. Ideally it would be nice to have the bars alternate the colors in the theme without a manual selection.  I know I can change the theme colors but the charts are all monochromatic. End-users are not interested in gradient colors, which is why I'm not taking the conditional formatting route.  

Is there a way to alter a theme that will give me alternating bar colors that are specific to a themed color? Are there different workarounds that I haven't throught of yet?

Random Colors based on Dax FormulaColor applied to "ALL" CategoriesTheme colors applied to bars in alternating fashion

Thank you!

[Ritaf1983 · Accepted solution]

Hi @Statcom  if the option of conditional formatting by category names / other logic doesn't help , then there is no solution to this request.

You can suggest it as the idea here:

https://ideas.fabric.microsoft.com/

Or maybe the rank functionality + conditional formatting can help, 
check the linked discussion:

https://community.fabric.microsoft.com/t5/Desktop/Alternating-colours-for-BAR-Graph-with-single-meas...

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly