Changing the data colors by group and adding the month to 40 columns in bar chart

[karlamaddox1]

Hello, 

I have some columns that I attempted to piviot but it broke my query. I have 40 columns with data that contains either "ABF" Not Available", "GPON", "or "Light Green" 

I had to group the values together to be able to show the number of times each of these options were selected in my column. 

Here are my questions- 

How can I change the color by each category ex: abf, not available, gpon, light green? (I will screen shot what it looks like when I do.. it only lets me do it by color resulting in 40 different colors) 

How can I add the month into this? The group that I made for the resultsThis is the graph I am working with.You can see here: the 40 columns I mentioned.

[v-chenwuz-msft · Accepted solution]

Hi @karlamaddox1 ,

Please try put the [groups] field your created by Groups in Legend of this stacked visual.

Then the color of columns is show as the screenshot.

Pbix in the end you can refer.

Best Regards

Community Support Team _ chenwu zhu

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

[amitchandak]

@karlamaddox1 ,Not very clear.

if you are using a stacked visual I doubt you can use conditional formating (if you need named color based on category)

[karlamaddox1]

You may be right, what is another chart I can use?