Relevant Data in Slicer

[desmon316]

I have a slicer where I want to disply relevant years and months.

I have set the Date Month and Year to Not Empty and Not Blank. I have set a filter for Financial Year, which only includes for this financial year and Also I have a slicer for the slicer where I want a relevant Data. 

The slicer and the data is from the same table.

None of this hides out the months and years which have no associated data in the page. 

Is there a way to hide out the fields which have no data associated.

[PaulDBrown]

How is the model set up and which fields are you using in the slicers?

[desmon316]

@PaulDBrown ,

There is a table with multiple dates with different meanings behind it. The Date of Win/Loss is created for only those rows which have been awarded or lost. Just now I changed the Date of Win/Loss not to include any value for those rows which aren't awarded or lost. I have another column which is called Financial year. I have used it as a filter for the page and for the slicer to not include historic data for this page. Still I can see the dates in the past.

In the slicer I am using the Month and year. For the slicer I have now used a filter which doesn't consider blanks or empty fields.

Hope this helps

[PaulDBrown]

So your model contains a single table?

[desmon316]

Yes it does.

[Anonymous]

What is the reason you have so much years ahead with date tables?

I d rather suggest to filter down in power query the empty blank windows, or set condition from xxx year till today. It will be better for refresh performance and size of file

[desmon316]

@Anonymous Unfortunately I can not filter those that are not in those years. As it is important data for the business.

[Anonymous]

It would be much faster if you could upload date table to see how its builded.

I assume date hierarchy is created from win/loss date??

[desmon316]

Yes, Date Heirarchy is from Win/Loss Date