cancel
Showing results for
Did you mean:
Frequent Visitor

## Slicer

Hi All,

I have a slicer that contains three products apple,redmi, and one plus when I click apple it filters all apple values from a table, how can I achieve this one. Please help me. Thanks in advance.

Following table

For example, when I click apple means the total sale value shown is 1500 and redmi means the total value shown is 1200. Please help me. Thanks in advance.

1 ACCEPTED SOLUTION
Microsoft

I did a local test，below are test screenshot select Redmi

select Apple ：

Here are my steps：

At first I created 3 measures to sum the 【product has the specific string apple oneplus or redmi

`hasapple = SUMX(Table4, IF(CONTAINSSTRING(MAX([product]),"apple"),1,0))hasoneplus = SUMX(Table4,IF(CONTAINSSTRING(MAX([product]),"oneplus"),1,0))hasredmi = SUMX(Table4,IF(CONTAINSSTRING(MAX([product]),"redmi"),1,0))`

then I create a measure to connect these measure and slicer ，Table5 is the slicer table

`filtermeasure = SWITCH( TRUE(),SELECTEDVALUE('Table5'[product])="Apple" ,[hasapple],SELECTEDVALUE('Table5'[product])="Redmi" ,[hasredmi],SELECTEDVALUE('Table5'[product])="Oneplus" ,[hasoneplus],1)`

Then in visualization  I can use this measure to filter the table ：

Select the table， add the measure as filter，then select is 1 ，then press the apply filter button

Best Regards,

Community Support Team _Isabella

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

3 REPLIES 3
Microsoft

I did a local test，below are test screenshot select Redmi

select Apple ：

Here are my steps：

At first I created 3 measures to sum the 【product has the specific string apple oneplus or redmi

`hasapple = SUMX(Table4, IF(CONTAINSSTRING(MAX([product]),"apple"),1,0))hasoneplus = SUMX(Table4,IF(CONTAINSSTRING(MAX([product]),"oneplus"),1,0))hasredmi = SUMX(Table4,IF(CONTAINSSTRING(MAX([product]),"redmi"),1,0))`

then I create a measure to connect these measure and slicer ，Table5 is the slicer table

`filtermeasure = SWITCH( TRUE(),SELECTEDVALUE('Table5'[product])="Apple" ,[hasapple],SELECTEDVALUE('Table5'[product])="Redmi" ,[hasredmi],SELECTEDVALUE('Table5'[product])="Oneplus" ,[hasoneplus],1)`

Then in visualization  I can use this measure to filter the table ：

Select the table， add the measure as filter，then select is 1 ，then press the apply filter button

Best Regards,

Community Support Team _Isabella

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

Frequent Visitor

@amitchandak thanks for your reply, but my requirement is when I select apple in a slicer all cells that contain apple should be filtered.

Super User

@Shreeram04 , Please split the product column of table 2, using split by delimiter in power query

Split Column Power Query: https://youtu.be/FyO9Vmhcfag

New Power BI Features
Datamarts: https://youtu.be/8tskWsJTEpg
Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Dashboard of My Blogs !! Connect on Linkedin !! Proud to be a Super User!
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
!! Subscribe to my youtube Channel !!

Announcements