Hide/remove bookmarks after selecting a value in slicer

[AnnaMagnusson]

Hi!

Is there a way to hide/remove bookmarks after they have gotten "old"?

I have several bookmarks to filter forecast of sales and actual sales for different products.

(I am using bookmarks since I can't connect my dim_table to my main_table)

One product should only be in the report for 5 years after launch date. So if a product is launched in 2017 and if I select 2024 in the slicer then it should be hidden. But if I have 2020 selected then it should show the bookmarks again.

Is that possible? Or is there a better solution to use?

[nvprasad · Accepted solution]

Hi Anna,

You can use conditional formatting on font color to achieve this. please refer below snapshot. Need to create measure to determine max year to show visible font color (in above scenorio 2020).

Appreciate a Kudos! ‌‌
If this helps and resolves the issue, please mark it as a Solution! ‌‌

Regards,
N V Durga Prasad

[AnnaMagnusson]

@nvprasad 

Thanks for the tip. I'll try to use it and see if it works for me!