Custom Slicer for PII

Hi Andrew_T ,

To solve this problem, I recommend you to use field parameter. Because you have 16 columns, sometimes you don't need to display so many columns at once, and the field parameter can help you filter the fields.

Step1:

First, we go to Modeling and click on new parameter. Then we select Fields.

Now, simply select any fields you would like to include from the table.

Here is a link of tutorial about field parameter: Field Parameters in Power BI - Microsoft Fabric Community

Step2:

Now, we go to the Report page and select any elements you wish to search.

Below is an example.

Step3:

To search for any names where there is no postcode or telno, we can use Q&A.

Go to Q&A setup, and click on Teach Q&A.

If you want to search for any customer who leaves telno blank, enter a question like “telno blank” and it will show the result at bottom right.

Here is a link showing the instruction of using Q&A: Use Power BI Q&A to explore and create visuals - Power BI | Microsoft Learn

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.