Forum Discussion
Slicer is showing Duplicate Values
Hi, utsavlexmark
Normally, Slicer will display distinct values in a column. If there are duplicate values displaying in a Slicer, it is very likely that some spaces or non-printable characters before or after the values.
You can try these solution to see whether your problem can be solved.
Quick Tips for cleaning & de-duplicate your data in Power BI
Best Regards,
Caiyun Zheng
If I answer your question, please consider marking my post as a solution!
Hi, utsavlexmark
Normally, Slicer will display distinct values in a column. If there are duplicate values displaying in a Slicer, it is very likely that some spaces or non-printable characters before or after the values.
You can try these solution to see whether your problem can be solved.
Quick Tips for cleaning & de-duplicate your data in Power BI
Best Regards,
Caiyun Zheng
If I answer your question, please consider marking my post as a solution!
Thanks Caiyun,
It is working perfectly for me now. It was really surprised to see that the issue is not there in the Desktop file but in Online version reportview.
Thank you very much for your help.
Regards
Utsav
To be very honest I don't know what the reason was 😂
https://community.powerbi.com/t5/Desktop/Duplicate-values-in-slicer-Please-help/m-p/478036 this post actually helped to show the data I want to show.
