Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Display Message if Data Suppression is Applied

Hi All,

I am attempting to create a page that displays trended leaver rates based on employee gender. This page will include slicers for the ability to slice by business unit and job and we wish to protect employee data against small sample sizes. In order to protect employee confidentiality, we do not wish to display data for months in which the total leaver count was less than 5. To help our end users, we would like to display a message if any month had a leaver count below the threshold of 5. The visual with suppression applied has the visual level filter below applied set to 1.

 

Show Hide Leaver = IF([Leaver Count Measure]<5,0,1)

 


The message I was trying to display has the following logic. This message is only displayed if the total count across all months is below 5, which is not what we want.

 

Leaver Message = IF([Leaver Count Measure]=0,"",IF([Leaver Count Measure]<5,"Suppression is being applied"))

 


Below is a sample image of what the trended data would look like without and with suppression applied.




Thanks


Data Protection

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi @Theriaux ,

    I created a sample pbix file(see attachment) for you, please check whether that is what you want. 

     

    If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

    How to upload PBI in Community

    Best Regards

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hello,

      I've attached a PBIX file with sample data. In this example, since the leaver count for the months of March and June is below the threshold of 5, I want the message to display to act as an indicator of suppression being applied for our end users.

      Data Suppression Test

      Thanks