Ranked item color

[Anonymous]

Hello,

I have three bar charts showing the top 10 best-selling items for the week, for the month and for the year.

Can the columns have the same color if they relate to the same item?

I mean, if "chair" is red in the first chart, "chair" will be red in the second chart and there will be no red column in the third chart because "chair" is not represented.

What can I do to get closer to this rendering?

[RobbeVL]

How many items does your dataset contain ? 

Robbe

[Anonymous]

Hello,

Currently, I have got 188 items in my dataset.

Grob

[RobbeVL · Accepted solution]

1 Dreadfull way would be to remove your "TOP" filter, add all colors manuallly per item and then copy the visual and change aggregation.

An other way could be to add a "rank/index column" to your ProductDimension , and define conditional formatting based on that index/rank) .

Did i help you here somehow? should i be more concrete? 

Robbe 

[Anonymous]

Actually, I do not control data and calculated columns; I am in DirectQuery mode. So my actions are very limited.

I guess I have to think of another way to render information because it will be to difficult to color item by item.

Thank you for your answer!