Slicer Only Relevant Values

[Anonymous]

Hello, 

I have combined the main table to the date reference table to get the Fiscal Date Period using Many to One. However, the slicer of the fiscal period includes all date values from the date reference table. Is there a way to show only relevant values?

My main table has 4 years starting 2018 while the date reference table has 6 years starting 2016. I only want the slicer to have shown all dates in 4 years but it is showing all years even those that have no data.

Thanks!!

[jdbuchanan71 · Accepted solution]

@Anonymous 

You can write a simple measure to count the rows in your main table, something like.

Data Count = COUNTROWS ( 'Your Table Name Here' )

Then you assign that as a filter on your slicer and set it to 'is not blank' and click apply.

[amitchandak]

@Anonymous , Put one of the measures from fact into the slicer and check for not null/blank

Very similar to this https://www.youtube.com/watch?v=cyOquvfhzNM

[Anonymous]

Any measure will do?