Slicers Not Working Correctly

[Anonymous]

I have a simple model. Sales and calendar tables. The calendar table was created using calendar auto and marked as the date table. Whenver I select a specific row in the table for the year 2021, the year slicer still shows every week for the year. data does not exist for them yet. I tried a single and bi-directional relationship. Is this a bug?

[v-yuaj-msft]

Hi @Anonymous ,

The information you have provided is not making the problem clear to me. Can you please explain with an example? 

Can you share some sample data and the expected result to have a clear understanding of your question?

Best Regards,

Yuna

[FarhanAhmed]

Try using "Power Slicer" from Marketplace if you can, and put measure as a filter in it. 

This will filter out Slicer selection upon any selection made on other visuals.

[ebeery]

@Anonymous please share the details of the relationship you have between the sales and calendar tables (i.e. what are the key fields being related?)

[Anonymous]

they are linked by date fields. The date in calendar and the transdate in sales.

[ebeery]

@Anonymous add a filter to your year and/or week "slicer" to only show items when the "Sales" measure is not blank.

Marco Russo had a great explanation of how/why to do this in a livestream today

https://youtu.be/76CrSzaLbYY?t=1035 

[ebeery]

Ok @Anonymous, you're going to have to provide a little more information if we're going to be able to figure this out...

What is meant by "the year slicer still shows every week for the year"?  Can you provide a screenshot unexpected results you're seeing?

[amitchandak]

@Anonymous , Sometimes table to slicer interaction are not on. Check that.

https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions

Also do not prefer bi-directional join. You can take a measure from fact and add a visual level filter in the week slicer for that measure is not null.

refer this example for the way, work for one slicer too -https://www.youtube.com/watch?v=cyOquvfhzNM

[Anonymous]

That video seems to be showing somethig that has been a default behaviour, when you select the year, you should only be able to select week 5 because no other weeks exist from a data perspective.

[Anonymous]

These changes make no difference.