How can I hide the 'Others' label in a Limitation of Fixed Number when its expression value is zero?

[julioarriaga]

Hi everyone,

As always, I appreciate your invaluable help. We're building a pie chart for a high executive in which I am using the first 3 (two in my example) dimensions with the highest value and an Others label. The thing is sometimes the Others's value is zero, so I want it to hide it in the pie's legend when that happens, but I can't find a way of doing it. And in my opinion, being the visualization for a director, this gives a bad image.

As it is a pie chart, the sum of the values need to be 100%, so I don't see how can I use rank for the solution, but I'm open to ideas.

Kind regards.

I add images and the qvf file.

Image 1: The pie chart

The Others label is in the legend, although its value is zero

Image 2: The undesired 'Others' label when the value is zero.The undesirable 'Others' label

Image 3: The data table

The data table

Image 4: The configuration

The configuration

[kuba_michalik · Accepted solution]

Wow, I didn't know that the pie chart does not have the option to hide zero values in Add-ons > Data handling. Awesome consistency 🙄

You can achieve what you need through set analysis, change your formula to:
Sum({<Dime={"=Sum(Expre)>0"}>} Expre)