Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Remove Duplicates in Slicer

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

 

 

Reports

2 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    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's avatar
      Anonymous
      Not applicable
      8 years ago

      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