Forum Discussion
Filter/slicer with 2 values on the same columns
Super UserHi,
Create a 2 column Table (Table2) with all fruits and cities in column 1 and Fruit or City in column 2. Build a relationship from the Data column of Table1 to the Data column of Table2. Create a slicer from column 2 of Table2. To your visual, drag the Data column from Table1. Write this measure
Measure1 = SUM(Table1[sales])
Hope this helps.
Hi,
Thanks for your response,
was tried with below approch,unfortunalty no luck .
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.
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
Hi,
Column 2 of Table2 should have Fruit or City depending upon the entry in column A.
Hi,
Thanks for your response here is the screen please have a look :
- Ashish_Mathur
Hi,
In Data2 column of Table2, the entries should be Fruit, City, Fruit, City, City, Fruit, Fruit, City. Create a slicer from this column.