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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
GraceC
Helper I
Helper I

Slicer not displaying correctly

Hi all. I have a slicer that filters a graph by month. For the months Jan-June (the months I used when I originally built the dashboard) display correctly i.e. when June is selected the slicer says June is selected. I have recently updated the dashboard to include July and August. Now when I select August, the slicer says 'All' even though it has correctly filtered for August. June etc still displays correctly. Note, I have the option to select all turned off. Any advice on why this is happening would be greatly appreciated. Thanks, Grace

1 ACCEPTED SOLUTION

Thanks so much for your help but I just discovered the issue! There is a limit to the number of drop down options you can have and my dates went back too far. 

View solution in original post

6 REPLIES 6
v-yulgu-msft
Microsoft Employee
Microsoft Employee

Hi @GraceC,

 

Did you use the dropdown slicer? Could you provide more details so that I can reproduce this scenario? If possible, please share your .pbix file.

 

Does this odd behavior exist if you drag other fields into this slicer? Have you tried to delete and re-create this slicer? If this problem always occur in any report file, please update your dekstop to latest version for a test.

 

Best regards,
Yuliana Gu

 

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-yulgu-msft,

 

Thanks for your response!

-Yes it's a dropdown slicer

-The behaviour exists when I drag other fields into the slicer

-I have deleted and re-created the slicer multiple times

-I have the latest version of Desktop Power Bi

 

When I select "August" or "July" it will momentairly say "August" or "July" but as soon as I click anywhere else it reverts back to "All" but will still show results for August or July. For all previous months it will stay on the right month. I've checked each month entry has the same data type and format. I'm very confused!

 

Cheers

Grace

Hi @GraceC,

 

I didn't encounter this problem in my environment (2017 September). Could you share your pbix file so that I can test in my desktop to see whether issue occurs?

 

Regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi,

Sorry for the silly question but how do I share a pbix file with you?

Grace

Hi @GraceC,

 

You can upload your pbix file on OneDrive, then, share the link with me so that I can download.

 

Regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks so much for your help but I just discovered the issue! There is a limit to the number of drop down options you can have and my dates went back too far. 

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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