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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

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

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
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! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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