Same value in a column but it is differentiated. Need help ASAP!

[syeena]

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".

[Samarth_18 · Accepted solution]

Hi @syeena ,

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.