Display period with data in slicer

[tmhalila]

Hello,

I have a slicer for the annual period and from the database, the Calendar is designed to start from year 1 ... like FY01. Now I just want to display years with data only in my slicer, to avoid a long list of years for users

Any idea you are welcome

[Greg_Deckler · Accepted solution]

@tmhalila Create a measure: Selector = COUNTROWS('Table'). Use that in your Filters pane for greater than 0.