Combined search option for slicer

[viswaaa]

Hi All,

I have a report with columns for Workspacename,Reportname and KPIname

I need to give only search option for the slicer SO I used Text Search Slicer.

Now my other requirement is I need to create a combined search on Workspacename,Reportname and KPIname.

Please let me know how to create this.

[v-pgoloju]

Hi @viswaaa,

Just following up to see if the Response provided by community members were helpful in addressing the issue. if the issue still persists Feel free to reach out if you need any further clarification or assistance.

Best regards,
Prasanna Kumar

[v-pgoloju]

Hi @viswaaa,

Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to @Tahreem24 and @AliceW  for prompt and helpful responses.

Just following up to see if the Response provided by community members were helpful in addressing the issue. if the issue still persists Feel free to reach out if you need any further clarification or assistance.

Best regards,
Prasanna Kumar

[Tahreem24 · Accepted solution]

@viswaaa You can create a new calculated column using DAX or Power Query by combining these 3 columns and use this on slicer for searching.

DAX Column = Table[Workspacename] & Table[Reportname] & Table[KPIname]

Use the above column in slicer for searching.

[AliceW]

You could create a column combining the three you need (in PowerQuery, Add Column, and select the three).