cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

Limit on slicer entries

Hi,

I have a column called "Partner".  When I drop that onto a table along with various data columns, it has 25 entries, all of which have data attached.

On a second table (which is a copy of the first table but on a new page) I created a slicer based on the same partner field, but it only shows 20 names, the first 19 and then the very last entry (sorted alphabetically).

The slicer is set as a drop down, but changing it to a list makes no difference.

Any ideas?

Thanks,

Glynn

 

3 REPLIES 3
Community Support
Community Support

Hi @ghammond09 ,

 

“On a second table (which is a copy of the first table but on a new page)”

Does the [Partner] column of your copy table really contain 25 different values? If yes, did your slicer add filters?

 

Do you mind show us the .pbix file?

Or the sample data and screenshots of visuals.

 

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helper I
Helper I

Hi,

No, it is a simple list of 25 names with data showing.

Thanks,

Super User III
Super User III

@ghammond09 ,

 

Have you checked if the table visual has duplicated values ? It happens when you have different values for the entire row.



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors