Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
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
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
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
64 |