Forum Discussion

cathtiffin's avatar
cathtiffin
Regular Visitor
6 years ago
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 could become so.

 

Thanks,

Data Protection
Need Help
  • mahoneypat's avatar
    mahoneypat
    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

3 Replies

  • mahoneypat's avatar
    mahoneypat
    Microsoft Employee
    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

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    6 years ago

    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