Remove Duplicates in Slicer

[Anonymous]

Hi All,

  I get the duplicate data in slicer when i sort the slicer by another feild .without sorting it shows unquie data.how can i remove that duplicate in slicer.

Any suggestions would be appreciated.

Thanks,

Chunduri

[v-jiascu-msft]

Hi Chunduri,

The values of the slicer are all from the source table. Please check the source table if there are some invisible parts in the values. For example, the spaces. 

If you still can't solve it, please provide a sample and some snapshots. 

Best Regards,

Dale

[Anonymous]

Thanks for Reply @Dale.

The problem is not in source table.If I sort normal way it did not shows duplicate data.But when we use sort by using other column it shows duplicates because it has different combinations . Anyway we solved the problem by writing the query.

i.e we take the another query with the startdate and term columns and taking minimum value of startdate and groupby term and join the main query and this query.

Thanks,

Chunduri