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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
Solle
Helper III
Helper III

Date table showing all values despite no data

Hi All, 

I have created a date table from this website using the code presented there, this gives me my date table, which I mark as "Date Table" in powerBI. Then I connect it to my current "AsOfDate" as shown below (Before connecting I have checked that both columns are formatted the same way):

Solle_0-1651133332130.png

Then I try to apply the date table in a slicer that I have, however this gives me all the dates as per below, despite that my data only have four data points:

Solle_1-1651133554410.png

 



Solle_0-1651133545700.png

 


Does anyone know how to solve this issue? 

Best Regards,
Solle

1 ACCEPTED SOLUTION

Hi All, 

I solved it by allowing for cross filtering to both tables. 

Thank you! 

View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

@Solle , Take a measure from samelet Data and use it the visual level filter of slicer and check this is not blank

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Hi @amitchandak

Thank you for your fast reply, I have done so, please see the attached screenshot.

Solle_0-1651135396748.png

Best Regards,
Solle

Hi All, 

I solved it by allowing for cross filtering to both tables. 

Thank you! 

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.