Top 5 bar chart colouring, 'others' is grey

[stijnval]

Hi experts,

I am trying to create a bar chart displaying a top 5. The fifth value would cover all other values. We can accomplish this by checking the Others option in the fixed limitation section. However, this value is always grey. Is there any option to change it so that it matches the colouring of the other bars?

Thanks!

Stijn

[YoussefBelloum]

Hi,

would you be able to share a QVF ?

[ruanhaese]

Hi

Remove the "Show Others" Below the "Limitation" on the Dimension.

Then it will only display the Top 5

The 5th value on yours is that large because it collects the total of all the others.

If you remove the "show others" then it only limits it to the Top 5

(i.e. its currently Top 4 + Others - not Top5)

[OmarBenSalem · Accepted solution]

Create your dimension as a master item (master dimension) and there u can define the color of OTHERS:

ps: create ur dimension, then click on it to edit it; that's how u could access to its color

I choose red; result:

[stijnval]

Thanks for your response! However, I would like to show the fifth value as being 'Others'

[stijnval]

Thanks for your response! This does the trick when I make masteritems for the measures.

[YoussefBelloum]

Try using rank() function