Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |