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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
PowerRon
Post Patron
Post Patron

Let slicer show only available years in fact table

Hi

 

I have a Date table (marked as Date table) and a Fact table.
The Date table contains, amongst others, a separate Year field.
There is 1:n relations between Date – Facts.

Date table contains dates from 2010-01-01. Fact table contains data from midst 2016.

Suppose the Date table has a surrogate key, which relates him to the Fact table.
I want to create a slicer containing Years. How do I take care of the fact that this slicer will only contain Years for which there are facts?

What solutions/possibilities do I have?

Regards
Ron

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@PowerRon , take a measure from fact and check for not blank

 

measure = sum(Table[value])

 

Check-in visual level filter measure is not blank.

 

This might not work with date range

 

 

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@PowerRon , take a measure from fact and check for not blank

 

measure = sum(Table[value])

 

Check-in visual level filter measure is not blank.

 

This might not work with date range

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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