Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
utsavlexmark
Helper III
Helper III

Slicer is showing Duplicate Values

Hello,

Let me first give you a picture of the data set:

Date

Tracking Code

Landing Page

Visits

Unique Visitors

Page Views

1st Feb 2021

Xyz

a.html

1

1

1

2nd Feb 2021

Zyx

b.html

1

1

1

3rd Feb 2021

Xyz

a.html

1

1

1

4th Feb 2021

Zyx

b.html

1

1

1

5th Feb 2021

Xyz

a.html

1

1

1

 

Now I am using “Tracking Code” as a slicer. In the slicer I can see tracking code “Xyz” is showing 3 times, but it should be showing once. In slicer if I try to select “Xyz” more than once it is not happening. Even if try to select the 3rd “Xyz” – the first one gets selected.

Data in the dashboard is having no issue.

My concern is why I am seeing Duplicate Tracking Code in the slicer?

If I am not clear with the scenario – please let me know.

Regards

Utsav

1 ACCEPTED SOLUTION
v-cazheng-msft
Community Support
Community Support

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.

Duplicate values in slicer

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!

View solution in original post

9 REPLIES 9
v-cazheng-msft
Community Support
Community Support

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.

Duplicate values in slicer

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

@utsavlexmark 

So what was the problem causing duplicate values in your slicer?

regards

Phil?



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


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.

manikumar34
Solution Sage
Solution Sage

@utsavlexmark , 

 

Can you check if any whitespaces before or after the letters. If you have any please TRIM.

 

Regards, 

Manikumar





If this helps, Appreciate your KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




PhilipTreacy
Super User
Super User

Hi @utsavlexmark 

No that shouldn't be an issue.  I've recreated your sample data and it works fine for me.

 

Download the PBIX file and check yourself, maybe you'll spot something 

 

slitra.png

Regards

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Hello Phil,

Just discovered one strange thing. The issue I pointed out is only showing in online verson in report view. This issue is not there in the Power Bi Desktop file. 

Please suggest something - I am totally confused with this.differeces.jpg

PhilipTreacy
Super User
Super User

@utsavlexmark 

Check the values for Xyz in the Tracking Code column are identical.Are there are any leading or trailing spaces or other unprintable characters?

Regards

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Hello Philip,

They are identical, nothing is there to separate them. 

I have a doubt - as you can see in my dataset, same tracking code and landing page might have been use in different dates. Is that creating any issue?

Regards

Utsav

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.