Forum Discussion
Same value in a column but it is differentiated. Need help ASAP!
| Animal |
Bear |
| Dog |
| Bear |
| Cat |
| Tiger |
Based on the sample table above, supposedly I would have 4 distinct values and 0 unique due to the "Bear" on first row is the same as the "Bear" in the third row. However what I am getting is 4 distinct values and 1 unique in which the unique is one of the "Bear" in any row. The spelling and capitilaztion both are the same yet how do I group it as a single "Bear"? Because when accessing in slicer, there will be two options of "Bear".
Hi Anonymous ,
Ideally, it should not happen if everything is the same then it should show only 4 values in the slicer(one value for bear). However, you can keep unique values in the slicer by creating a separate table for unique values as below:-
Table_slicer = DISTINCT('Table'[Animal])Connect this table to your animal column and use the table_slicer column as the slicer column.
1 Reply
Samarth_18Community Champion
Hi Anonymous ,
Ideally, it should not happen if everything is the same then it should show only 4 values in the slicer(one value for bear). However, you can keep unique values in the slicer by creating a separate table for unique values as below:-
Table_slicer = DISTINCT('Table'[Animal])Connect this table to your animal column and use the table_slicer column as the slicer column.