Forum Discussion
Ranked item color
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?
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
4 Replies
- RobbeVL
Impactful Individual
How many items does your dataset contain ?
Robbe
- RobbeVL
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