clustered column chart, all colors appeared in columns, now they are gone

[LucasAlcarde]

Clustered column chart, all colors appeared in columns, now they are gone

It made changing the colors a lot faster when they all appeared, now I can only change them one by one. what could be added is conditional formatting and not removing something.

[Anonymous · Accepted solution]

Hi @LucasAlcarde 

With reference to the information provided by you, I ran the following tests:

Here's my test data.

I created the following measure:

Measure = SWITCH(TRUE(),
SELECTEDVALUE('Table'[number]) <= 10, "yellow",
SELECTEDVALUE('Table'[number]) > 10 && SELECTEDVALUE('Table'[number]) <= 20, "blue",
SELECTEDVALUE('Table'[number]) > 20, "pink"
)

With this clustered column chart selected, I did what is shown here.

Is this the result you expect?

If this is not the outcome you were hoping for. Please provide detailed sample data and the results you are hoping for. So that I can help you better. Show it as a screenshot or excel. Please remove any sensitive data in advance.

Best Regards,
Community Support Team _Yuliax
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[LucasAlcarde]

in a pbix file the column chart appears the color to change, but it does not change, it returns to the initial default color alone, and in another file the color with category "ALL" does not appear, strange