Forum Discussion
Slicer and table show duplicate options
Hi Echoy51
It seems like you have hidden spaces in your data set.
Try to trim and clean it from the PQ :
if it will not help
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.