Forum Discussion
Solved
Hiding small figures
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 co...
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
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