Hiding small figures

[cathtiffin]

Hi ,

is there a way of not showing figures less than 10% for example in visuals? Im looking at displaying characteristics and though individuals arent identifiable if sliced in the right way they could become so.

Thanks,

[v-juanli-msft]

Hi @cathtiffin 

Answers above are very helpful.

If the problem still occurs, please show more details.

for example, what does this mean?

Im looking at displaying characteristics and though individuals arent identifiable

Best Regards

Maggie

[mahoneypat · Accepted solution]

Two suggestions:

1. You can build a threshold into your measure like this

MyMeasure = var __asum = SUM(Table[Column])

return IF(__asum <0.1, BLANK(), __asum)

2. You can also put a threshold so people can never drill down to the single person level (actually they can drill down but won't see a result)

MyMeasure = IF(COUNTROWS(VALUES(Table[Person]))<5, BLANK(), SUM(Table[Column]))

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[lbendlin]

Look for the "Top N and Other" pattern.