Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Help needed!! Data anonymization

Hi all, 

 

I recently made a Dashboard that displays the results of a survey distributed throughout the company. 

 

The Dashboard allows users to drill down into the survey results using multiple filters. Amoung these filters are the filters on "Job Grade" and "Project Name". 

 

Since there are some projects that only have one "Senior Manager" staffed, it would be posible for visitors to find out what the answers are of some particular respondents. 

 

Since we promised the survey could be filled in anonymous, I am now looking for a solution/workaround in the dashboard.

 

Question: Is there a method/workaround to hide the results in the dashboard if the number of respondents is less than 3?

 

All tips are welcome 😉

 

Thanks in advance,

 

Jur

Data Protection
Need Help
Show and Tell
Tips and Tricks
  • negi007's avatar
    negi007
    5 years ago

    Anonymous   I think it is possible, please do the following. If you have less or equal to 3 responses then "No Result" will be shown else orginal response will be shown on the visual

     

    1. Create a calculated column 

    Response_New = if (DISTINCTCOUNTNOBLANK(Tab[Response_Orginal]) <=3 ,"No Result", Tab[Response_Orginal])
     

     

    In case you wish to combine condition basis multiple columns, you can modify the dax above as well.

3 Replies

  • negi007's avatar
    negi007
    Community Champion
    5 years ago

    Anonymous   I think it is possible, please do the following. If you have less or equal to 3 responses then "No Result" will be shown else orginal response will be shown on the visual

     

    1. Create a calculated column 

    Response_New = if (DISTINCTCOUNTNOBLANK(Tab[Response_Orginal]) <=3 ,"No Result", Tab[Response_Orginal])
     

     

    In case you wish to combine condition basis multiple columns, you can modify the dax above as well.
    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thanks for your response! I found out that conditional formating is an easier workaround

  • v-deddai1-msft's avatar
    v-deddai1-msft
    Community Support
    5 years ago

    Hi Anonymous ,

     

    Thank you for sharing the workaround. Would you please consider Accept it as the solution to help the other members find it more quickly?

     

    Thanks for your understanding and support.

     

    Best Regards,

    Dedmon Dai