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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
carlosDash
Advocate V
Advocate V

Slicer missing values, displays only one - bug or a feature?

I'm unable to get the slicer visual to list all unique values found inside my column. Currently it only lists one single value (apparently it's the most common value in the table) when there are at least a dozen different values it should display as choices. For another column it only lists four different values even though there are again at least a dozen different ones.

 

Here's a screenshot:

 

PBIDesktop_2017-02-01_13-03-38.png

 

Is this a bug or is there an issue with my data/settings?

2 REPLIES 2
v-ljerr-msft
Microsoft Employee
Microsoft Employee

Hi @carlosDash,

 

According to your description above, I just verified that the Slicer works all fine for me without the issue. 

 

What's your data source? Are you using the latest version of Power BI Desktop(2.42.4611.701 64-bit (January 2017))? Could you share a sample pbix file which can reproduce the issue? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.Smiley Happy

 

Regards

 Unfortunately I can't share any of the data or datasources. I was using an SQL query as the data source. I can no longer recreate the issue, everything seems to be working fine now. I seem to be getting bugs/issues every now and then, but I can't easily recreate them. I'm using the latest January version of Power BI desktop.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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