Forum Discussion
cathtiffin
6 years agoRegular Visitor
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...
- 6 years ago
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
6 years agoSuper User
Look for the "Top N and Other" pattern.