Filter/slicer with 2 values on the same columns

Question

Hi All,&nbsp;I am trying to create slicer on same column whihc will have 2 types of data - please find below more details&nbsp;&nbsp;&nbsp;

ashish_mathur · Answer

Hi,
Create a 2 column Table (Table2) with all fruits and cities in column 1 and Fruit or City in column 2.&nbsp; Build a relationship from the Data column of Table1 to the Data column of Table2.&nbsp; Create a slicer from column 2 of Table2.&nbsp; To your visual, drag the Data column from Table1.&nbsp; Write this measure
Measure1 = SUM(Table1[sales])
Hope this helps.

anonymous · Answer

Hi,Thanks for your response,was tried with below approch,unfortunalty no luck .&nbsp;as you mentioned created a new table with 2 columns , column1(Data) as is with main table and Column2 has only Fruits. when i use column2 from table 2 - i am getting all the fruits and nulls as well.&nbsp;what i am looking in the slicer is - slicer should have only 2 values - Fruits and Cities - so that i can select either one of them or both.

ashish_mathur · Answer

Hi,
Column 2 of Table2 should have Fruit or City depending upon the entry in column A.

anonymous · Answer

Hi,&nbsp;Thanks for your response here is the screen please have a look :

ashish_mathur · Answer

Hi,
In Data2 column of Table2, the entries should be Fruit, City, Fruit, City, City, Fruit, Fruit, City.&nbsp; Create a slicer from this column.

Forum Discussion

Filter/slicer with 2 values on the same columns

9 Replies

Related content

Slicer for filtering several columns

Time Filter Slicer

Filter Slicer values based on another slicer

Single Slicer to Filter Multiple Columns

Filter Table by Column Values Associated with Selected Slicer Values