How to create a slicer based on multiple string values per row

Question

Hi All,&nbsp;&nbsp;I currently have a dataset that looks a bit like the table below, and need to create a slicer that gives the respective amount with the distinct string values in the column Category.&nbsp;The expected behavior is that the slicer says HOR; THR; COM; DRA and if I select&nbsp; THR I get a sum of all amounts with thr (1,200,000) or a count of all categories with THR (3)&nbsp;Thank you in advance for any help!

anonymous · Accepted Answer

sloane&nbsp;, Please split the column by delimiter this way you will get the separate values.&nbsp;The rest will work as expected:&nbsp;Did I solve your problem?&nbsp;Please mark my answer as a solution!

Forum Discussion

How to create a slicer based on multiple string values per row

2 Replies

Related content

Creating multiple Audiences in PowerBI App

Creating date slicer removes data

Text slicer: pasting multiple values

Creating a dynamic slicer

Slicer for Multiple-Choice Values