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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
SeanB004
Frequent Visitor

slicer selecting Blank instead of 1

Hi 
I have this table : 

SeanB004_0-1693301794306.png

and a slicer feeding from the above table.

SeanB004_1-1693301845636.png

When I select Current Month, the slicer shows a blank value but when I select Current Quarter it selects the right value. 
How do I make sure it selects the right value and doesnt return a blank.

When "Current Month" is clicked:

SeanB004_2-1693301971770.png
When "Quarter" is selected:

SeanB004_3-1693302045607.png

 

 

1 ACCEPTED SOLUTION
Sergii24
Super User
Super User

Hi @SeanB004, I've tried to replicate your issue but everything works fine:

Sergii24_0-1693306405214.png

 

My suggestions would be the following:

  • Verify that you don't have any "visual level filters" on Card VisualSergii24_1-1693306523077.png
  • Replicate the same scenario in new PowerBI Desktop file. If it works well, there is some issue in your *.pbix file
  • Delete both visuals and add them to canvas again: first on a new page and then to the same one. In such way you can better identify where the issue comes from.

If nothing works, let us know about above outcomes 🙂

View solution in original post

1 REPLY 1
Sergii24
Super User
Super User

Hi @SeanB004, I've tried to replicate your issue but everything works fine:

Sergii24_0-1693306405214.png

 

My suggestions would be the following:

  • Verify that you don't have any "visual level filters" on Card VisualSergii24_1-1693306523077.png
  • Replicate the same scenario in new PowerBI Desktop file. If it works well, there is some issue in your *.pbix file
  • Delete both visuals and add them to canvas again: first on a new page and then to the same one. In such way you can better identify where the issue comes from.

If nothing works, let us know about above outcomes 🙂

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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