How to filter product list based on Year selection on Slicer?

[anish610]

I want to filter a product List containing

• Products A
• Product B
• Product C

for selected  Date year slicer 2022,

and it should display only 2 Products

• Product A
• Product B

for selected  Date year slicer 2023?

[anish610]

@amitchandak  Any help here?

[bolfri]

Put a filter on the product slicer to show only product that has any value in the data. Simply and works perfect!

eg. if you have a measure Sales = SUM(...) put it on product filter with condition that Sales is not blank 🙂

[anish610]

Thanks for the reply.
That cant work. As Product C does contain data for 2023. 
but by rule it should not be shown in 2023.

[bolfri]

dim_product: (that is connected to fact_sales)

product_id, product_name etc.

dim_calendar (that is connected to fact_sales)

date, year, quarter ctc.

fact_product_dates (that is connected to dim_product with two directions)

product_id, year_start, year_end

Create a measure that checks if product from dim_product table and selected year is betweeen year_start and year_end and set 1 or 0 rule. Set filter on viz to 1. 🙂

[marcelsmaglhaes]

Hey @anish610 

You need to have some date reference in your product table. For example, a created date. Somehow, you need to create a relationship between the products and the specific year to achive your goal.

Kind Regards,
Marcel